Bug #63633 Fetching tables for a connection (sql editor) is 10+ times slower

• Submitted: 6 Dec 2011 20:52
• Modified: 23 Dec 2011 20:19
• Reporter: Bob Dankert
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.36
• OS: Windows (W764)
• CPU Architecture: Any
• Tags: Fetching tables, regression, slow, sql editor

[6 Dec 2011 20:52] Bob Dankert

Description:
Fetching the table list is a little more than 10x slower than on previous versions.  This is after establishing a connection, and populating the list of tables and views in the upper right.  The connections are all remote servers (with SSL and compression), but I tested with a previous version of Workbench and this populated in ~2 seconds.  It now takes over 20 seconds to populate the list of tables/views for the database.  You also get the same effect by refreshing the database details.

How to repeat:
Open a connection.  Refresh the tables/views if needed, but it happens each time populating the list.

Suggested fix:
Restore the times for list population to that of previous versions (or similar), a 10 fold increase is a lot

[7 Dec 2011 5:08] Valeriy Kravchuk

Yes, this procedure is now really slow comparing to 5.2.35.

[7 Dec 2011 8:01] Valeriy Kravchuk

Bug #63587 was marked as a duplicate of this one.

[7 Dec 2011 11:37] Peter Laursen

I wonder: did WB change the statement it executes from SHOW FULL TABLES to SELECT FROM I_S?  In that case it is actually a server bug.

Petr
(not a MySQL person)

[23 Dec 2011 20:19] Philip Olson

Fixed as of 5.2.37:
Generating a list of tables and views was slow, when compared to the previous Workbench version.