Add Relationship Hang

[GoogleCodeExporter]

When clicking the Add button on "Relations" tab on a table, the application 
hangs for 30+ seconds at which point the dialog eventually appears. This occurs 
every time I click the Add button, even after restarting application, MySQL 
server (etc).

This has only started occurring since upgrading to 0.9.9.1 today.

Original issue reported on code.google.com by jbr...@resharmonics.com on 2 Sep 2011 at 9:43

[GoogleCodeExporter]

FYR; I am still using Snow Leopard on this machine. I have not yet tried 
0.9.9.1 on my Lion machine.

Original comment by jbr...@resharmonics.com on 2 Sep 2011 at 9:45

[GoogleCodeExporter]

Hi,

how long does the query below take to execute?
How many rows does it retrun?
How many tables has this db?

SELECT DISTINCT constraint_name FROM information_schema.table_constraints WHERE 
constraint_type = 'FOREIGN KEY' AND constraint_schema = '##replace with your db 
name###';

Original comment by schlabbe...@gmail.com on 2 Sep 2011 at 6:03

• Changed state: WaitingOnUser

[GoogleCodeExporter]

I managed to reproduce this on a server with lots of databases & tables - on 
that host, the constraint listing takes ~30 secs.  This isn't dependant on 
setting the type and schema parts of the query - the list is presumably 
generated dynicamically...

Original comment by rowanb@gmail.com on 2 Sep 2011 at 7:59

• Changed state: Accepted

[GoogleCodeExporter]

Original comment by stuart02 on 3 Sep 2011 at 10:35

• Changed state: Started
• Added labels: Component-Logic, Milestone-Release0.9, Priority-Medium, Type-Defect, Usability

[GoogleCodeExporter]

Fixed in r3411.

Original comment by stuart02 on 4 Sep 2011 at 1:30

• Changed state: Fixed

[GoogleCodeExporter]

Issue 1189 has been merged into this issue.

Original comment by rowanb@gmail.com on 13 Sep 2011 at 9:36