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?