Re: [Tikiwiki-devel] Substantial forum speed improvements.

[Marc L. <ma...@ma...>]

 From #tikiwiki

(14:41:26) fumphco: mose: i have one data point for forum speed
(14:41:42) ohertel: fumphco: hey. Better? :)
(14:41:54) fumphco: forums->features->slow website
(14:42:03) fumphco: thread with someone complaining about speed
(14:42:21) fumphco: I recorded speed to refresh the thread in the posting
(14:42:35) fumphco: 
http://tikiwiki.org/tiki-view_forum_thread.php?comments_parentId=22188&topics_threshold=0&topics_offset=27&topics_sort_mode=lastPost_desc&topics_find=&forumId=4
(14:43:48) fumphco: page view was previously 2.3 secs, now is 1.8 secs
(14:44:07) fumphco: but i noticed that my site some times runs faster 
right after restart
(14:44:12) mose: not bad, but not that impressive
(14:44:19) ohertel: fumphco: hope that's not just less net lag. :)
(14:44:35) mose: robin talked about much more impressive boost
(14:44:46) fumphco: that's from bot bar
(14:45:44) ohertel: mose: but there is a static time we have always ... 
maybe that thread isn't big enough.
(14:46:03) ohertel: robin tested with thousands of entries ...
(14:47:12) fumphco: only 16 postings on the thread i'm using
(14:48:16) fumphco: looks like fewer queries being executed than before 
on my thread
(14:48:21) ohertel: sounds good then, for that few entries 0.5 sec 
faster... .)
(14:49:29) fumphco: when i recorded it a few days ago it took 367 
queries, no3 is 301 to 303
(14:49:40) fumphco: no3->now
(14:50:37) fumphco: refreshed a couple of times, low of 1.46 seconds, 
high of 1.8
(14:51:46) fumphco: i dont notice any irregularities, but like you said 
chibaguy is more frequent poster so would be better to say



Robin Lee Powell wrote:

>Anyone get a chance to look at these?
>
>-Robin
>
>On Sun, Oct 22, 2006 at 04:41:43PM -0700, Robin Lee Powell wrote:
>  
>
>>I was able to make *massive* improvements in the Forums' speed on
>>large data sets with a few simple removals/tweaks.  I have a client
>>with sixty thousand posts in their main forum.  It used to by that
>>trying to get the topic listing took minutes, if it ever came back.
>>It now takes less than two seconds.
>>
>>However, while I didn't change very much, I did excise an entire DB
>>call, and massively change another.  I would really like if people
>>would test, especially in large forums, and tell me:
>>
>>1.  Is it faster?
>>
>>2.  Is anything broken.
>>
>>The checkin is to HEAD, and the main files changed are below.
>>
>>-Robin
>>
>>Checking in tiki-view_forum_thread.php;
>>/cvsroot/tikiwiki/tiki/tiki-view_forum_thread.php,v  <--  tiki-view_forum_thread.php
>>new revision: 1.83; previous revision: 1.82
>>done
>>Checking in comments.php;
>>/cvsroot/tikiwiki/tiki/comments.php,v  <--  comments.php
>>new revision: 1.66; previous revision: 1.65
>>done
>>Mailing tik...@li......
>>Generating notification message...
>>Generating notification message... done.
>>Checking in lib/commentslib.php;
>>/cvsroot/tikiwiki/tiki/lib/commentslib.php,v  <--  commentslib.php
>>new revision: 1.141; previous revision: 1.140
>>done
>>Mailing tik...@li......
>>Generating notification message...
>>Generating notification message... done.
>>
>>-- 
>>http://www.digitalkingdom.org/~rlpowell/ *** http://www.lojban.org/
>>Reason #237 To Learn Lojban: "Homonyms: Their Grate!"
>>Proud Supporter of the Singularity Institute - http://singinst.org/
>>
>>-------------------------------------------------------------------------
>>Using Tomcat but need to do more? Need to support web services, security?
>>Get stuff done quickly with pre-integrated technology to make your job easier
>>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>>_______________________________________________
>>Tikiwiki-devel mailing list
>>Tik...@li...
>>https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>>    
>>
>
>  
>

-- 
M ;-)

//////////////////////////////////////////////////////////////////
/                                                                /
/ Marc Laporte       <|>                  http://marclaporte.com /
/ Avantech.net       <|>                     http://avantech.net /
/ Tiki CMS/Groupware <|> http://tikiwiki.org/UserPagemarclaporte /
/                                                                /
//////////////////////////////////////////////////////////////////