Clear cache in heidiSQL

TigorCoding's profile image TigorCoding posted 11 months ago in General Permalink

is there any way to clear cache in heidisql? i want to calculate query time but it is always 0,000 sec

1 attachment(s):
  • Screenshot-2023-10-08-122819
ansgar's profile image ansgar posted 11 months ago Permalink

You mean the server side query cache - yes you can disable it per SQL_NO_CACHE keyword in any query:

SELECT SQL_NO_CACHE title FROM book ...
ansgar's profile image ansgar posted 11 months ago Permalink

Note for debugging purposes you can also check the query profiler in the right helpers box, which will give you more accurate times:

Description

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