specific question about searching performance [message #13307] |
Mon, 29 September 2003 19:45 |
klieber
Messages: 1 Registered: September 2003 Location: NYC
Karma:
|
Junior Member |
|
|
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
Gentoo Linux
http://gentoo.org/
http://forums.gentoo.org/
|
|
|