|
index.php:
Page generated in 3.60033 seconds with 9 queries
1: SELECT * FROM cache WHERE id=1 (0.94689 sec)
2: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,u.membergroupids FROM user u LEFT JOIN session s ON s.userid=u.userid WHERE u.userid=1 (0.58092 sec)
3: SELECT groupid,cpaccess,modaccess,diskspace,uploadsize,uplimit,uploads,comments,editpho,editposts,useralbums,reqmod,canassign FROM usergroups WHERE groupid=6 LIMIT 1 (0.00378 sec)
4: SELECT id FROM photos WHERE approved=0 (0.00304 sec)
5: REPLACE INTO iponline (userid,ipaddr,date,what,item) VALUES ('Thomas','213.183.87.178','1130244351','index','') (0.00110 sec)
6: DELETE FROM iponline WHERE date < 1130243751 (0.00045 sec)
7: SELECT cat,laston FROM laston WHERE userid='1' (0.27459 sec)
8: SELECT userid,date FROM iponline ORDER BY date DESC (0.00252 sec)
We use standard gzip encoding on php level, not especially in pp.
The above queries sum up to 1.81 secs - so we have 1.8 secs left used for moving data from / to mysql/apache and processing the php itself - can you send me a version of index.php to trace throug the single parts of the script?
Last edited by dontom; October 25th, 2005 at 08:09 AM.
|