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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.