MySQL Bugs: #30214: Edit/Create Table dialog takes many seconds to appear (connecting over internet)

Bug #30214	Edit/Create Table dialog takes many seconds to appear (connecting over internet)
Submitted:	2 Aug 2007 22:45	Modified:	26 May 2009 13:09
Reporter:	Allen Pike	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	MacOS (10.4.10 Intel)
Assigned to:		CPU Architecture:	Any

Description:
When you try to edit or create a table, the dialog takes an extremely long time to come up. On my 2Ghz 2GB Intel Mac, it takes 7 seconds for the dialog to appear. This is much more time than it takes for me to SELECT * FROM a 10,000 row table.

To make things worse, while you're waiting, there's no indication of progress. An indication of progress is particularly vital since the Query Browser can crash quite frequently, so you often think it's crashed when it pauses for such a long time. Of course you shouldn't need to indicate progress of a simple dialog coming up.

How to repeat:
- Click on a database name in the Drawer.
- Context-click on the database, and choose "Create Table."
- Wait 7 seconds.
- Lose your train of thought.

Suggested fix:
Time the different parts of the code that brings up the dialog, to see where the bulk of that lag is coming from. Clearly there is a bottleneck or erroneous behaviour that is causing this.

Thank you for the report.

I can not repeat described behaviour on MacBook 2GHz with 2Gb RAM. Please provide `top` output.

Using "top" and Activity Monitor, I can see that it's not CPU bound, but rather network bound. Network access spikes (though only to 8KB/s) while Query Browser is  waiting to bring up the Create Table dialog.

It looks like:
- Brief CPU spike
- Seconds of receiving network data
- Brief CPU spike

I have no idea what you'd need so much network access for to bring up the Create Table dialog. It maxes at 8KB/s even though I can easily download 50 times faster than that - maybe a large number of sequential connections?

Thank you for the report.

Verified as described. To repeat set up slow network and use Query Browser.

Should be feature request "Show wait cursor" though, because MySQL Query Browser has nothing to do with network lags.

Note: the connections that get me seven-second delays are business-grade cable connections of 3Mbps, with less than 100ms latency. I would imagine that as long as your connection goes over the internet, this issue will show itself.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/