[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.

[Author]

Posts