|
| quote: | Originally posted by Streakfury
Is anyone else having trouble with the search function?? It seems to me like it's got worse over the last year or so, and recently I keep getting "there seems to be a problem, blah, blah..." messages. |
in answer:
| quote: | Originally Posted by Swamper
it never worked "perfect", in fact, it bottlenecks the server more than you understand. The vb2 default way of handling search is by creating a HUGE index of words and posts and referencing that - what I use now - is the database server's built-in FULL TEXT SEARCH (MySql 4.x+) which has algorithms that are much faster and results in less overhead from DISK I/O to get the job done.
The problem (which is intermittent) is that database corruption happens at backup time when it shouldn't since it locks all the tables prior and does a repair after the copy - it is not consistent.
If its broken at 11AM it'll stay broken till at least 5:30 AM EST - which is when the next copy takes place - unless I do a manual repair prior. Today's screwup happened on the index of the post table (as opposed to search/user) - so - to do a repair on that would result in the forums being down for 20 minutes (not worth it) - so - today's search is using the main database - which means - the forum will likely bottleneck at peak times today - but - search will work. |
and also i think he has taken out the specific forum search, as well as searching latest threads. so now it works, but without full functionality..
___________________
MUGGETS
|