MySQL Forums
Forum List  »  Knowledge Base

slow response on listing tables in database
Posted by: Malcolm Cowen
Date: May 14, 2008 04:08AM

An application (in Realbasic) has been working well at Client's site for a long time.

Suddenly it fails to connect to a remote MySql at website server.

We can connect with PhpMyAdmin OK and display list of tables within database OK.
We can connect with Mysql Query Browser utility OK, but clicking on a database to expand the list of tables (about 600) takes 50 secs. (Clicking on smaller databases is correspondingly quicker.)

It looks as if the program on the PC (both Realbasic and Php Query Browser) has suddenly started doing a handshake for every table in the database, which is silly.

Does anyone know if this can happen, and what can cause it (it certainly was not happening before)

Options: ReplyQuote

Written By
slow response on listing tables in database
May 14, 2008 04:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.