Bug #35948 Foreign Key Reference Column taking 20-30 seconds to populate
Submitted: 9 Apr 2008 19:16 Modified: 11 May 2008 0:46
Reporter: Joseph Morgan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.17 OS:Windows (XP)
Assigned to: Alfredo Kojima CPU Architecture:Any

[9 Apr 2008 19:16] Joseph Morgan
Description:
When creating a foreign key on the foreign key tab of the table editor, when I click on the table's column to select the reference column, the reference column drop-down refreshes about 30 times, taking about 20 seconds to complete.

It seems to work correctly afterwards.

The problem increases as more tables are added to the model.

How to repeat:
Start creating a bunch of tables, and create foriegn keys for them.  As more and more tables are added, the drop-down list starts to repeatedly refresh itself.  When I had about 15 tables, I counted it refresh 21 times.
[9 Apr 2008 19:48] MySQL Verification Team
Thank you for the bug report. I could not repeat with a model project with 17
tables. Could you please provide the output of Help->System Info like the
showed below?. Thanks in advance.

Looking for user plugins in C:\Documents and Settings\miguel\Dados de aplicativos\MySQL\Workbench\modules
Looking for user plugins in C:\Documents and Settings\miguel\Dados de aplicativos\MySQL\Workbench\plugins
MySQL Workbench SE for Windows version 5.0.17
Cairo Version: 1.5.12
Rendering Mode: GDI Rendering
OpenGL Driver Version: Not Detected
OS: Windows XP
CPU: Intel(R) Celeron(R) M CPU        420  @ 1.60GHz, 0.9 GB RAM
Video adapter info:
Adapter type: ATI RADEON XPRESS 200M Series
Chip Type: ATI display adapter (0x5A62)
BIOS String: BK-ATI VER008.050I.026.000
Video Memory: 65536 KB
[9 Apr 2008 20:00] Joseph Morgan
As a follow-up.  For an unrelated reason, I shut down WorkBench and restarted it.  The first foreign key I tried to create thereafter populated the drop-down once.  The next one refreshed 6 times.  Interestingly enough, the very next one refreshed 3 times.  So, it doesn't seem to matter so much how many tables, as it may be related to how many times in a single running session one creates a foreign key.  

Here is my system information:

Looking for user plugins in C:\Documents and Settings\joseph.morgan\Application Data\MySQL\Workbench\plugins
MySQL Workbench OSS for Windows version 5.0.17
Cairo Version: 1.5.12
Rendering Mode: GDI Rendering
OpenGL Driver Version: Not Detected
OS: Windows XP
CPU: 2x Genuine Intel(R) CPU           T2500  @ 2.00GHz, 2.0 GB RAM
Video adapter info:
Adapter type: ATI Mobility Radeon X1400
Chip Type: ATI Mobility Radeon X1400 (0x7145)
BIOS String: BK-ATI VER009.012.001.020.021243
Video Memory: 524288 KB
[10 Apr 2008 18:55] Johannes Taxacher
this has been improved (teste in SVN Rev 3037)
[11 May 2008 0:46] Paul DuBois
Noted in 5.0.18 changelog.

The Reference Column dropdown used during foreign key creation was
slow to display.