GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Why is the vbulletin search feature such garbage?

Babaganoosh · 11-04-2010, 05:29 AM

The DB has over 16 million posts in the main forum. 99% of vbulletin sites don't have even a tiny fraction of the data and traffic GFY has. Can you imagine how many fulltext searches are being done against a db of 16 million+ rows?

Have you looked at the vbulletin source related to the search? Frankly it's not bad at all. The bottleneck is MySQL or more accurately the hardware it's running on. Personally if GFY were mine mysql would be running on a load balanced cluster.

11-04-2010, 05:29 AM
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	The DB has over 16 million posts in the main forum. 99% of vbulletin sites don't have even a tiny fraction of the data and traffic GFY has. Can you imagine how many fulltext searches are being done against a db of 16 million+ rows? Have you looked at the vbulletin source related to the search? Frankly it's not bad at all. The bottleneck is MySQL or more accurately the hardware it's running on. Personally if GFY were mine mysql would be running on a load balanced cluster. __________________ I like pie.