Menu
▾
▴
Re: [Tikiwiki-users] Re: [Tikiwiki-devel] Optimisation
|
From: Marc L. <mar...@av...> - 2005-04-27 13:44:57
|
Hi! I think it may be related with: Wiki comments are not counted like in 1.8 (now only top level) http://dev.tikiwiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=136 M ;-) Flo Gleixner wrote: > > Hi damian, > > i did some tests and i think the problem are comments on wiki pages. > If i don't have a comment on a wiki, i have 36 DB queries. If i add > comments, the 1st comment pushes the # of queries to ~60, then every > comment adds ~4 queries. I think there is a loop that could be solved > with a better sql query. > > Flo > > On Tue, 26 Apr 2005, Damian Parker wrote: > >> yo all, >> >> Tonight in IRC land there was a heated debate, >> >> we had a visitor from the very popular www.voip-info.org website. >> A personal favourite of mine. Currently running the latest 1.8.5 >> code it uses circa 296 queries to generate the HomePage. >> >> After a test upgrade to BRANCH-1-9 the exact same configuration >> and page went upto a mindboggling circa 550! >> >> This site ONLY uses the Wiki feature, with shoutbox and a last >> changes module, there is nothing fancy happening. >> >> I am very much interested in seeing your own tests of similar >> upgrades of 1.8.x to the latest BRANCH-1-9 from CVS or via >> de.tikiwiki.org tarballs before 1.9.0 is released. >> >> Personally I know a lot of people are waiting for this release, >> but with this kind of increase in queries on a very basic home >> page I feel there is need for concern, others have already >> disagreed in IRC tonight and are pushing the release. >> >> Please respond with your own tests. >> >> A quick guide to creating a dump of 1.8 and the upgrade >> procedure: >> >> 1) dump the database: mysqldump -u username -p dbname > mysql.sql >> (will prompt for the password) >> 2) create a new database >> 3) mysql -u username -p newdbname < mysql.sql >> (will prompt for the password) >> 4) Download or CVS checkout the latest 1.9 code >> 5) Extract and setup permissions >> 6) Run tiki-install and feed in the new database connection settings >> 7) Run tiki_1.8to1.9.sql via tiki-install >> 8) Start compiling your statistics :) >> >> More comprehensive instructions can be found on these pages: >> >> * [http://tikiwiki.org/InstallTiki] >> * [http://tikiwiki.org/UpgradeTo19] >> >> Cheers to all! >> >> -- >> >> >> Damian Parker >> Damosoft - TikiWiki Support, Development and Training >> http://www.damosoft.co.uk / http://tikihost.net / http://tikiwiki.info >> Telephone - 0845 004 3923 IAXtel - 700-168-0333 FWD - 72453 >> Full Online Support Tracking at - http://support.damosoft.net >> >> >> ------------------------------------------------------- >> SF.Net email is sponsored by: Tell us your software development plans! >> Take this survey and enter to win a one-year sub to SourceForge.net >> Plus IDC's 2005 look-ahead and a copy of this survey >> Click here to start! http://www.idcswdc.com/cgi-bin/survey?id=105hix >> _______________________________________________ >> Tikiwiki-devel mailing list >> Tik...@li... >> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel >> > > > ------------------------------------------------------- > SF.Net email is sponsored by: Tell us your software development plans! > Take this survey and enter to win a one-year sub to SourceForge.net > Plus IDC's 2005 look-ahead and a copy of this survey > Click here to start! http://www.idcswdc.com/cgi-bin/survey?id=105hix > _______________________________________________ > Tikiwiki-users mailing list > Tik...@li... > https://lists.sourceforge.net/lists/listinfo/tikiwiki-users > -- M ;-) ////////////////////////////////////////////////////////////////// / / / Marc Laporte <|> http://marclaporte.com / / Avantech.net <|> http://avantech.net / / Tiki CMS/Groupware <|> http://tikiwiki.org/UserPagemarclaporte / / / ////////////////////////////////////////////////////////////////// |