Searching text data for words and substrings is deceptively difficult to do efficiently. What are the options, and how do they compare? This talk will compare several solutions for full text search, including MyISAM FULLTEXT, InnoDB FULLTEXT, Sphinx Search, Solr, Xapian, and trigraphs.
Track:Trends in Architecture and Design
12 April 15:00 - 15:50 @
Principal Trainer, Percona, Inc
Bill Karwin has been a software engineer for over twenty years, developing and supporting applications, libraries, and servers such as Zend Framework for PHP 5, the InterBase relational database, and the Enhydra Java application server. Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems. Bill authored the book "SQL Antipatterns", collecting frequent blunders and showing better solutions.