Subject RE: [firebird-support] searching a varchar(100) column
Author Lee
You wrote:

Can somebody tell me how to speed up search on a book title column
(varchar(100)), the user will be usually entering first 2 or 3 words of the
title. What I am using now is LIKE, but this is very slow on a table which
contains 120000+ records.

Any suggestion are greatly appreciated.

Thank you.


I don't know how it would work for you, but I use a separate table for
something like this in a shopping cart application. I juse fill the table
with relavent keywords from the field I want to search (excluding things
like "is", "and", "I", "or", etc) and search on those. Of course each
keyword in the separate table has a FK to actual record of the table the
keywords are derived from.

Sorry couldn't be much help.