Quote:
Originally posted by nakkid
george, this is what i get on your board:
[high]Page generated in 0.4542080 seconds (93.83% PHP - 6.17% MySQL) with 17 queries.[/high]
i reload it 10times and i never got a negative value.
i'm beginning to believe is the browser's fault.. and i'm not even neo.. hehe
|
strange if i log out and do explain first time i got 0.11 for 17 queries but reloading i get 15 queries
Page generated in 0.092332 seconds with 15 queries,
spending 0.029972076416016 doing MySQL queries and 0.062359923583984 doing PHP things.
this is the query that got time reduced the most on subsequent reloads
PHP Code:
Query: SELECT template,title
FROM template
WHERE (title IN ('forumhome_birthdaybit','error_nopermission','forumhome_pmloggedin','forumhome_welcometext','forumhome_logoutcode','forumhome_newposts','forumhome_todayposts','forumhome_logincode','forumhome_loggedinuser','forumhome_loggedinusers','forumhome_lastpostby','forumhome_moderator','forumhome_forumbit_level1_nopost','forumhome_forumbit_level1_post','forumhome_forumbit_level2_nopost','forumhome_forumbit_level2_post','forumhome','forumhome_unregmessage','timezonelist','timezone_city','timezone_city_col','gobutton','timezone','username_loggedout','username_loggedin','phpinclude','headinclude','header','footer','forumjumpbit','forumjump','nav_linkoff','nav_linkon','navbar','nav_joiner','pagenav','pagenav_curpage','pagenav_firstlink','pagenav_lastlink','pagenav_nextlink','pagenav_pagelink','pagenav_prevlink')
AND (templatesetid=-1 OR templatesetid='10'))
OR (title = 'maxloggedin')
OR (title = 'birthdays')
ORDER BY templatesetid
Time before: 0.012995958328247
Time after: 0.027544975280762