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
