This chapter will explore how Drupal's search module works, explaining limitations introduced by the fact that SQL was not designed as a searching language. It will discuss how to get the best performance out of Drupal's search module, and how to know when it's time to look consider other alternatives. This chapter will mostly look at search in Drupal 6, but will take a brief look at why an improved search API is likely to be one of the killer features in Drupal 7.

1. Search Module Design
   1. Background
   2. Searching With SQL
2. Performance Bottlenecks
   1. InnoDB Performance
   2. When To Replace
3. Searching Drupal's Future
   1. Search API in Drupal 7
   2. Introducing Third Party Search Integration