FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » FUDforum 3.0+ » specific question about searching performance
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
specific question about searching performance [message #13307] Mon, 29 September 2003 15:45 Go to next message
klieber is currently offline  klieber   United States
Messages: 1
Registered: September 2003
Location: NYC
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
We currently have a fairly busy phpBB2-based forum, with ~540,000 posts, ~30k registered users and ~300 users online at any one time. Our search feature gets used heavily and is causing us a number of performance problems.

phpBB uses a wordmatch table for searching (much the same as fudforums does, I believe) meaning you initiate a search and it looks up the results in this table, which is 1.5GB. Now, when someone posts something to the forums, phpBB takes that post, pulls the relevant words out of it and inserts them into the wordmatch table. Because we use myisam tables, if you INSERT, you have to lock the entire table. So, user A makes a post and locks the wordmatch table while things are sorted.

In the mean time, users B, C, D and E initiate searches. These searches cannot complete because user A has the table locked. They queue up, which causes a traffic jam of sorts and the problem gets magnified from there. There also appears to be *something* in phpbb that causes some of those queries to never time out -- we've had numerous instances where we had to go in and kill search-related queries that were over an hour old.

So, my question: How does FUDforum handle this scenario and is it more efficient? (and if so, how?)

--kurt


Re: specific question about searching performance [message #13309 is a reply to message #13307] Mon, 29 September 2003 15:59 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Replied in IRC.

FUDforum Core Developer
Re: specific question about searching performance [message #22941 is a reply to message #13309] Mon, 21 February 2005 23:30 Go to previous message
duncanshannon is currently offline  duncanshannon   United States
Messages: 6
Registered: February 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
but what is the answer!
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Forum Deletion
Next Topic: Security from google searches
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 18 06:01:09 EST 2017

Total time taken to generate the page: 0.00796 seconds