MySQL Bugs: #40628: Works very slow with Relationships

Bug #40628	Works very slow with Relationships
Submitted:	11 Nov 2008 6:21	Modified:	28 Nov 2008 14:36
Reporter:	Andrew Moiseenko	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S5 (Performance)
Version:	5.0.27	OS:	Windows (XP SP3, .Net 3.5)
Assigned to:		CPU Architecture:	Any

Description:
MySQL Workbench works slower and slower with rise of number of relationships on diagram. I can create any number of tables and MySQL works fast, but when I begin to add the relationships it works slow: 
- after 6 relationships: slowdown in menu and renaming
- after 9 relationships: slowdown in dragging of tables, relationships selecting
- after 14 relationships: slowdown in all operations, even in minimizing of program' window.
I simply can't work with Workbench after 10-14 relationships added. Windows Xp Task Manager shows that CPU usage is about 90-100% during slowdowns. 

How to repeat:
Just add more relationships.

Thank you for the bug report. Could you please provide the output of Help->System Info and if possible a project file ready to see the behavior reported?. Thanks in advance.

Output of Help -> System Info

Looking for user plugins in C:\Documents and Settings\Andrew\Application Data\MySQL\Workbench\plugins
MySQL Workbench OSS for Windows version 5.0.27
Cairo Version: 1.5.12
Rendering Mode: GDI Rendering
OpenGL Driver Version: Not Detected
OS: Windows XP
CPU: 2x Intel(R) Pentium(R) 4 CPU 2.40GHz, 1.0 GB RAM
Video adapter info:
Adapter type: ATI Radeon 9600/9550/X1050 Series
Chip Type: ATI Radeon Graphics Processor AGP (0x4150)
BIOS String: BK-ATI VER008.017D.033.000
Video Memory: 131072 KB

Just simple student database

Attachment: Institute.mwb (application/octet-stream, text), 11.89 KiB.

Many thanks for writing a bug report.

I draw your whole database model again and look if it will occur same performance issues.

But I can't repeat it. Performance is very good here also after your I really re-draw all there is not a single hint that performance would be slow down.

I think this is not MySQL Workbench related. It is related to your Hardware.

Here is output from help system info from me:

Looking for user plugins in C:\Dokumente und Einstellungen\T60\Anwendungsdaten\MySQL\Workbench\modules
Looking for user plugins in C:\Dokumente und Einstellungen\T60\Anwendungsdaten\MySQL\Workbench\plugins
MySQL Workbench OSS for Windows version 5.0.27
Cairo Version: 1.5.12
Rendering Mode: GDI Rendering
OpenGL Driver Version: Not Detected
OS: Windows XP
CPU: 2x Intel(R) Core(TM)2 CPU         T7200  @ 2.00GHz, 1.0 GB RAM
Video adapter info:
Adapter type: ATI Mobility Radeon X1300
Chip Type: ATI Mobility Radeon X1300 (0x7149)
BIOS String: BK-ATI VER009.012.001.020.021243
Video Memory: 524288 KB

As you can see my video memory is much higher and also my bios is newer.

I think the issue of you is related to your video memory. I don't really think that bios is dependend here.