Expanding Database In Explorer Window Is Slow

[David Parker]

I have this problem with SQLYog that expanding a database icon to list its objects (tables, etc) is extremely slow for a large database. I just upgraded to 8.63 and I am still getting the same behavior.

What is puzzling is that on another machine running against a similarly configured database, with the same SQLYog version, expanding the database icon

in question is almost instantaneous.

Is there some configuration parameter that affects performance in this area?

Thanks.

[peterlaursen]

Are they connected to the net the same way?  Does 'a similarly configured database' mean the same database? Are the MySQL servers the same version?

SQLyog will query the MySQL server about the information to display.  Only when the server has returned the result we can populate the GUI. For instance to populate TABLES we execute (with 5.x servers):

Code:

SHOW FULL TABLES FROM `databasename` WHERE table_type = 'BASE TABLE';

I guess that the same statement takes equally much time if you execute from the SQLyog editor or any other client on same machine? If so this is a problem with the server and/or the connection and not with SQLyog.  Note that very early MySQL 5.0 servers can be slow with SHOW FULL TABLES FROM .. WHERE.

SQLyog only executes SQL.  Because that is the only way a MySQL client can communicate with the server.  The SQL we execute is recorded in HISTORY tab. So you can always copy statements generated by the GUI and execute from editor and any other client.

[David Parker]

Thanks for the reply. By “similarly configured” I mean that the databases have the same schema, roughly the same amount of data (one is dumped from the other periodically), and the same memory configuration.

In both cases the database is on the same machine as the SQLYog browser. Both machines are Windows 7, quad core, with 8GB of RAM.

I don't know, when I execute “SHOW FULL TABLES FROM `databasename` WHERE table_type = 'BASE TABLE';” on my machine, it returns immediately, while expanding the +'databasename' in the explorer pane takes several seconds.

But I understand that SQLYog just passes SQL. I wanted to make sure that there was not some configuration of SQLYog that I was missing. I'll just continue using SQLYog for some things and Toad for others.

Thanks.

[Mahesh]

It will be better to have web meeting.

Please tell us in which timezone you are in and suitable time to have online screen sharing session using GoToMeeting?

You can create a ticket for privacy

http://webyog.com/support

[Author]

Posts