I’ve toyed with Sphinx before. It blew my socks off… Until it broke.
Sphinx is an Open Source indexing engine, which is supported out of the box by the forum software, Invision Power Board (IPB). Essentially what Sphinx does, is run a bunch of queries against the IPB database, usually hosted on MySQL, pulling the entire post content (amongst other content types) and indexing it efficiently.
The result is blisteringly fast searches, arguably 10 times faster then the highly optimised MySQL queries employed by the IPB software. On a forum with over 1 million posts, containing over 1GB of text, SQL just can’t keep up. Continue Reading →

