OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Site performance issues

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> Site Feedback
View previous topic :: View next topic  
Author Message
draude
Administrator
Administrator


Joined: 10 Dec 2002
Posts: 353
Location: San Francisco

PostPosted: Thu Oct 04, 2007 3:14 pm    Post subject: Site performance issues Reply with quote

For some time now, there have been quite a few reports of bad site performance. These reports were always somewhat sporadic as far as timing but generally, they were accurate.

I've been analyzing performance over the last couple of days (since the upgrade) and definitely found some problem areas. The biggest one was that some custom queries (not phpbb queries) were not scaling well. These were fine when the data set was small but now that the data set is quite large, they're too slow. This problem became compounded tenfold when you had concurrent visits by search engine crawlers, i.e. Googlebot and Yahoo Slurp.

To remedy this situation, I've removed or modified these problematic queries to ease load on the database. The net effect is minimal and most of you won't notice the difference. But this should definitely make performance smoother and remove some of those rough spots. The only real rough spot that is unavoidable is the one associated with the db backup which locks the database for the duration of the backup. But that one is predictable.

I believe things should be much smoother from here.

Thanks.
Ed
Back to top
View user's profile Send private message Visit poster's website
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Thu Oct 04, 2007 4:46 pm    Post subject: Reply with quote

This thread should lead you to some information about "full text searching" (that's the term I remember anyway). It's a feature of mySql version 5 which supposedly lightens the load on the server caused by searching (in phpBB also), a lot of which is presumably done by the numerous "guests". ('terrian' is a name I adopted in an attempt to persuade others that I am indeed from this planet; I subsequently discovered the term is used in relation to an alleged species of extraterrestrial beings. I don't know whether the term "Freudian slip" can apply to extraterrestrial references.)
_________________
search forum by month
Back to top
View user's profile Send private message
draude
Administrator
Administrator


Joined: 10 Dec 2002
Posts: 353
Location: San Francisco

PostPosted: Thu Oct 04, 2007 7:15 pm    Post subject: Reply with quote

noranthon wrote:
This thread should lead you to some information about "full text searching" (that's the term I remember anyway).

Thanks. Yes, I'm familiar with mysql's full text search. I think it's been around since 4.0 or earlier. To be honest, I haven't looked at phpbb's search algorithm in detail. I agree it's not very good but I think it makes a pretty good tradeoff between functionality and performance. For more extensive searches, there's always Google.

At this point, I think guest searching has been less of a problem than some of the others I identified above. If the guest searching becomes problematic, it's really easy to limit searches to users only. Not sure how casual users would feel about that. Perhaps steering them toward Google (via a search box on the home page) makes the most sense. That coupled with making sure that Google indexes the entire site (which may not be the case as discussed in another thread).

Quote:
'terrian' is a name I adopted in an attempt to persuade others that I am indeed from this planet; I subsequently discovered the term is used in relation to an alleged species of extraterrestrial beings. I don't know whether the term "Freudian slip" can apply to extraterrestrial references.

LOL.

Ed
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> Site Feedback All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group