Since the Seach and Wordindex is getting really big, I have a little idea: Just have a look an this:
http://www.mysql.com/doc/F/u/Fulltext_Search.html
Quote:
Since Version 3.23.23, MySQL has support for full-text indexing and searching. Full-text indexes in MySQL are an index of type FULLTEXT. FULLTEXT indexes can be created from VARCHAR and TEXT columns at CREATE TABLE time or added later with ALTER TABLE or CREATE INDEX. For large datasets, adding FULLTEXT index with ALTER TABLE (or CREATE INDEX) would be much faster than inserting rows into the empty table that has a FULLTEXT index.
|
There seems to be a very good fulltext search in mySQL itself, why shouldnt vbulletin use it?