Bug #2134 Abnormally long time for select
Submitted: 16 Dec 2003 23:59 Modified: 1 Jun 2004 0:32
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQLCC Severity:S3 (Non-critical)
Version:0.9.2-beta OS:Windows (Windows 2000 Server)
Assigned to: Jorge del Conde CPU Architecture:Any

[16 Dec 2003 23:59] [ name withheld ] 
Description:
   I have a database with 7000+ tables.  When I make a selection from the table list sidebar, right click, select 'Open Table->Return all Rows ' it can take up to 3 minutes to display the results of the query.  There seem to be no display lag if using mysqldump for the table name, or accessing the table through a select statement in the sql query tool.  This only seems to happen when using the right click menu options.  This is being run on a Athalon dualproc 1800+ with 1.5GB of DDR memory, so I'm pretty sure its not a hardware performance issue.  If you wish I can send you a dump file from the database so you can simulate the same structures I have here.

How to repeat:
create a database with 7000+ tables
[17 Dec 2003 0:02] [ name withheld ] 
one thing I forgot to mention was that the tables being queried had no data so the cursor was empty.
[17 Dec 2003 0:09] [ name withheld ] 
I added a zipped dump file to this bug submission
[1 Jun 2004 0:32] Jorge del Conde 
Hi!

MySQLCC has been discontinued and will not be developed nor maintained anymore with the exception of Critical bugs.

In the near future we will release the substitute of MySQLCC called MySQL Query Browser.