Clear cache in heidiSQL

TigorCoding's profile image TigorCoding posted 1 year 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 1 year 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 1 year 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.