4-10 second delay displaying results. Duration says 0.000 sec and found row count = 1.

[expired user #10887]'s profile image [expired user #10887] posted 7 years ago in General Permalink

There is a long delay in displaying query results when connected to my larger database (2.5 GB), even if the query is just selecting from dual.

The query below takes a full 4 seconds to display the results.

select 1 from dual;

The editor comment says that the duration is 0.000 sec. If I run the same query (in HeidiSQL) when connected to a smaller database then it displays the results instantaneously. I also see the results instantaneously if I connect to the larger database from the command line prompt (not HeidiSQL).

Is there something I can do, or can HeidiSQL just not handle larger databases?

Please login to leave a reply, or register at first.