Sphinx - free full-text search engine
One amazing tool if you have a large database and what to speed up searching process and make advanced searching is the Sphinx search engine. And the best of all it's open source. I began my trip at Mike Cantelon's pdf and downloaded a test module named my_search and modified it.
There is a project on drupal for sphinx that I haven't tested.