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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
