What is a good/healthy mysql query execution time?
To my calculations:
The site gets 1000 unique visitors per hr
10 page view for each unique visitor
5 minutes for each unique visitor (I'm ignoring this. I should, right?)
1000*10=10000/(60*60) = 2.7 views per second.
I have 3 queries on every page. 2.7*3 = 8.1 queries per second
1 second/8.1 = 0.123
So average query execution time must be less than 0.123.
Assuming visits don't increase, can we say anything less than 0.123 works for a healthy database?