Re: slow website
some queries are done many many and many times. i don't understand why.
like this (a form page, don't look at the total line):
42624=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42625=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42626=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14702
42627=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42628=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42629=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14703
42630=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42631=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42632=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14704
42633=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42634=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42635=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14705
42636=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42637=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42638=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14706
42639=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42640=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42641=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14707
42642=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42643=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42644=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14708
42645=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42646=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42647=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14709
42648=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42649=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42650=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14710
42651=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42652=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42653=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14711
42654=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42655=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42656=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14712
42657=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42658=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42659=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14713
42660=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42661=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42662=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14714
42663=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42664=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42665=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14715
42666=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42667=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42668=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14716
42669=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42670=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42671=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14717
42672=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42673=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42674=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14718
42675=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42676=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42677=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14719
42678=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42679=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42680=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14720
42681=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42682=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42683=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14721
42684=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42685=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42686=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14722
42687=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42688=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42689=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14723
42690=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42691=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42692=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14724
42693=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42694=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42695=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14725
42696=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42697=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42698=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14726
42699=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42700=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42701=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14727
42702=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42703=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42704=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,
TOTAL=14728
42705=====>select `posts`, `level` from `tiki_user_postings` where `user`=? | xandra,
42706=====>select `filename`,`filesize`,`attId` from `tiki_forum_attachments` where `threadId`=? | 34911,
42707=====>select count(*) from `tiki_forums_reported` where `threadId`=? | 34911,