PDA

View Full Version : A little help here with the "standarderror" query


VirtueTech
Wed 17th Oct '01, 1:13pm
Hello everyone,

If you look at the "errornoid" and "standarderror" queries in the scripts via "showqueries=1" you'll notice a difference in load time for the "standarderror" qeury over the "errornoid" query and they are literally the same.

Any ideas why?

Check it out:

Query: SELECT template FROM template WHERE title='error_noid' AND (templatesetid=-1 OR templatesetid='1') ORDER BY templatesetid DESC LIMIT 1
Time before: 0.05300498008728
Time after: 0.054149985313416

--------------------------------------------------------------------------------

Query: SELECT template FROM template WHERE title='standarderror' AND (templatesetid=-1 OR templatesetid='1') ORDER BY templatesetid DESC LIMIT 1
Time before: 0.054608941078186
Time after: 0.15448594093323


Any ideas on how to fix this?

Freddie Bingham
Wed 17th Oct '01, 1:20pm
Did you refresh the page multiple times to see if that is the general load time?

I wouldn't worry about it too much though as the error template queries do not make up much percentage of mysql load time.

VirtueTech
Wed 17th Oct '01, 1:23pm
Yes I tried that. Check here:
http://forums.paintballcity.com/showthread.php?showqueries=1