Re: [GENERAL] ILIKE '%term%' and Performance

2005-12-05 Thread Stephan Vollmer
Hi! CSN wrote: > 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 i

[GENERAL] ILIKE '%term%' and Performance

2005-12-05 Thread CSN
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 o