The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
|||||||
|
#33
11-02-2002, 09:34 PM
|
|||
|
|||
I have another question for you php and mysql experts!
Lets say there is a line like this: eval("\$closeopenthread = \"".gettemplate("newthread_closeopen")."\";"); That line is in my showthread.php file. It has the eval thing, does that mean it's adding a query? If so, how do I change it so it doesn't? 
|
|
#34
11-02-2002, 09:46 PM
|
|||
|
|||
|
I did this explain thing and what on earth does all the stuff mean
 Query: SELECT template FROM template WHERE title='colforumtablefooter' AND (templatesetid=-1 OR templatesetid=1) ORDER BY templatesetid DESC LIMIT 1 Time before: 0.51396095752716 Time after: 0.51483500003815 table type possible_keys key key_len ref rows Extra template range title title 32 2 where used; Using filesort Like that, I just don't know, I mean it's the template table, but I don't understand what to do? Ok this looks bad: Query: UPDATE user SET lastactivity=1036276130 WHERE userid=1 AND lastactivity<1036276130 Time before: 0.19920098781586 Time after: 0.2000550031662 -------------------------------------------------------------------------------- Query: UPDATE user SET lastactivity=1036279082 WHERE userid=1 AND lastactivity<1036279082 Time before: 0.20031905174255 Time after: 0.200718998909 -------------------------------------------------------------------------------- Query: UPDATE user SET lastactivity=1036278622 WHERE userid=1 AND lastactivity<1036278622 Time before: 0.20096302032471 Time after: 0.20142102241516 -------------------------------------------------------------------------------- Query: UPDATE user SET lastactivity=1036278025 WHERE userid=1 AND lastactivity<1036278025 Time before: 0.20167303085327 Time after: 0.20206105709076 -------------------------------------------------------------------------------- Query: UPDATE user SET lastactivity=1036277677 WHERE userid=1 AND lastactivity<1036277677 Time before: 0.20230603218079 Time after: 0.20269000530243 -------------------------------------------------------------------------------- Query: UPDATE user SET lastactivity=1036277096 WHERE userid=1 AND lastactivity<1036277096 Time before: 0.20292901992798 Time after: 0.20330798625946 -------------------------------------------------------------------------------- Query: UPDATE user SET lastactivity=1036276868 WHERE userid=1 AND lastactivity<1036276868 Time before: 0.20354700088501 Time after: 0.20392203330994 -------------------------------------------------------------------------------- Query: DELETE FROM session WHERE lastactivity<1036280063 Time before: 0.2041449546814 Time after: 0.20440900325775 -------------------------------------------------------------------------------- Query: DELETE FROM search WHERE dateline<1035675763 Time before: 0.20457899570465 Time after: 0.2589670419693 Those are the last few queries in showthread...
|
|
#35
11-02-2002, 09:56 PM
|
||||
|
||||
|
I perfer using showqueries=1
I'm not sure as to what the tables that are produced mean, but you can see each query that is run, and the time each one is taking. As for the eval bit, if the template name is not in $templatesused before global.php is required then one extra query is added, otherwise no extra query for it.
|
|
#37
11-02-2002, 10:51 PM
|
|||
|
|||
|
you'll find that all of them in the eval statement is in the templatesused.
Just ones that aren't called often or rarely are left out as it would be a waste of time to fetch those pages with the rest.
|
 |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 06:40 AM.