ernest1a Posted March 30, 2010 Share Posted March 30, 2010 I am wondering what execution time is still ok tested with ab.exe considering that a script will be run on each pageview. And how can you know if execution time is because a script and query were cached? For example if my I test in ab.exe script takes 0.156 seconds. If I try again it showes 0.047s. If I make query in phpmyadmin, it showes execution time 0.036 (probably query was already cached). I am really confused how to test it and how to know what was cached. Link to comment https://forums.phpfreaks.com/topic/197003-php-and-mysql-benchmarking-on-localhost/ Share on other sites More sharing options...
gizmola Posted March 31, 2010 Share Posted March 31, 2010 Mysql has an option -- SQL_NO_CACHE that can be used to suppress the mysql query cache. You supply this in the actual select statement: SELECT SQL_NO_CACHE * from table Link to comment https://forums.phpfreaks.com/topic/197003-php-and-mysql-benchmarking-on-localhost/#findComment-1034491 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.