I'm thinking of enabling searches that use queries like "select * from items where title ilike
'%term%'". The items table has tens of thousands of rows. Is it worth worrying about the
performance of such a query (since, if I'm not mistaken, it will never use indices). If it is,
what's the best option - use tsearch? How does tsearch (or whatever else) compare performance-wise
to not using it, or to typical index-based queries for that matter?
thanks
csn
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs