Searching without the Database
Paul Reinheimer (Mar 12, 2010 at 11:00)
Talk at ConFoo.ca Web Techno Conference (English - US)
Many users are search dominant, they come to your site and look for the search box. <em>That</em> is their one true way of finding content. Unfortunately, searching with most databases is expensive, and often very limited (ignoring short strings, common words, etc). Your database probably has more important problems to solve.
Sphinx (and memcached) to the rescue!
This talk will walk you through the process of getting your data into sphinx, configuring your indices, and some tips on best use. Finally, storing your data in memcached for speed and glory.
This talk is based on information gained when rolling sphinx out to a site serving over 20 million unique visitors per day.
Quicklink: http://joind.in/1383
Mar 14, 2010, 15:04 by jelofson
After this talk, I am really looking forward to setting up sphinx and giving it a whirl. My sites are tiny in comparison to the example in the talk, but what the hey! I like the example of the drop-down menu and how the great speed of this search made it possible.