High Performance Full Text Search for Database Content
Peter Zaitsev, Co-Founder, Lead Consultant, Percona Ltd

Track: Web
Date: Tuesday, 19 September 2006
Time: 10:00 - 10:40
Location: Theatre Plaza

Most of the web sites on the Internet today are database driven. The constantly increasing amount of information each web site has to offer makes Full Text Search features very important, and the growing traffic and data size requires delivering Full Text Search service with high performance.

In this presentation we're using MySQL as an example to show how Full Text search can be organized. You will learn:

  1. Not all Full Text Search is equal: what you need to know to select the solution right for your application.
  2. MySQL Build In Full Text Search: what factors affect performance ? How to get the performance and quality you're looking for.
  3. What other solutions can be used to index database content. We'll briefly speak about Lucene, Mnogosearch, Sphinx Search -- frequently used alternatives to MySQL Build in full text search.
  4. Performance. We'll use Wikipedia english articles database to see how different solutions compare in speed and search quality using real world scenario.