the first thing that comes to mind is to add an index to the table/field in question. With a well normalized design, this usually helps.
Note however, that nothing comes for free. (the old saying "There's NO such thing as a Free Lunch," comes to mind.) While indexing often improves searches, it will slow down inserts, deletes, and updates (if the indexed field is changed.) Plus, it makes the database larger.
Without knowing more about the table design and usage, it's difficult to offer any more relevant responses. For instance, what is the field type that you're searching? Does the field contain a single word, or is it more or less free-form text? What do the current SQL queries look like?
Last edited by loquin; 09-07-07 at 13:30.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert