...

View Full Version : test speed



BubikolRamios
11-01-2011, 11:27 AM
Whichever gui I try for running queryies it works lik this:
1.first run, takes like 5 sec
2.all next emidiate runs of same queriy takes 0,03 sec. (looks like server caches something ?)

How can one then real test query speed ?

BubikolRamios
11-02-2011, 02:09 AM
http://www.techiecorner.com/45/turn-on-mysql-query-cache-to-speed-up-mysql-query-performance/

so, this:


SET query_cache_type = 0; RESET QUERY CACHE ;


affects this:



SHOW VARIABLES LIKE '%query_cache%'


& affect speed, to be 'slow'



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum