>> OK - any application that allows user-built queries: <choose column:
>> foo> <choose filter: contains> <choose target: "bar">
>> Want another? Any application that has a "search by name" box - users
>> can (and do) put one letter in and hit enter.
>> Unfortunately you don't always have control over the selectivity of
>> queries issued.
> -*- HOW TO MAKE A SEARCH FORM -*-
> Imagine you have to code the search on IMDB.
> This is what a smart developer would do
All good domain-specific tips to provide users with a satisfying
None of which address the question of what plan PG should produce for:
SELECT * FROM bigtable WHERE foo LIKE 's%'
In response to
pgsql-performance by date
|Next:||From: Arnau||Date: 2007-05-25 17:16:05|
|Subject: Re: How PostgreSQL handles multiple DDBB instances?|
|Previous:||From: Joshua D. Drake||Date: 2007-05-25 17:06:46|
|Subject: Re: LIKE search and performance|