[thelist] constructing a good search string/query

[Dan McCullough]

Not sure what I did.  *nothing*.  but it seems to be performing light
years faster.  it seems that it wasnt overwritting the old code when I
was moving the code and so therefore my old psudo code was probably
the reason for the slowness.

:(

On 5/2/05, Roger Ly <evolt at matchpenalty.com> wrote:
> >Here is the query.
> >select * from search_string where lower(searchstring) like
> >'%"+searchTerm+"%'
> 
> How the does the query compare when run without the lower function?  Is it
> faster?  You could consider creating a functional index on search_string for
> lower(searchstring) to help optimize the query.
> 
> Roger
> 
>