Quote:
Originally Posted by solarist
This is a problem in most forums unfortunately - if they software indexed all the short/common words, it would take the server to it's knees
|
Well the problem is that MYSQL is a very bad engine, and that Vbulletin is some of the worst code I have ever seen, and even worse database design.
SQL as a technology is more than capbable of doing the job, its Vbulletin that is at fault.
I used to write banking databases I could query 4 TB databases and get replies on data sub 3 seconds.
Its not so much in the indexing but how the database is designed and rationalized. Does it conform to 3rd normal - etc.
Xtreame