[thelist] constructing a good search string/query

Dan McCullough dan.mccullough at gmail.com
Mon May 2 15:26:05 CDT 2005

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

More information about the thelist mailing list