Sorry I've been gone lately--been crazy!
Anyways, I had an idea (scary huh?
Since how to restore your database if it's large is a very popular topic on phpBB and since 90% or more people use MySQL, would there be any problem that I don't see with using MySQL's LIKE clause on searches instead of using the indexes?
50% or more of the database is just the search indexes so a lot of time in restoring could be saved if they weren't used.
Now I know using LIKE on big forums would cause a slow down, but wouldn't it work okay for small to medium sized forums?
I guess by not updating the search tables when posting/editing would speed up the server a bit too.
Hope this makes a little sense!
Thanks for any insight!