[thelist] constructing a good search string/query

[Dan McCullough]

Yes for the final process I took out the lower as there was no need
for it.  but for the exercise I was checking if that was causing it,
so I was taking it in and out.  What a head ache this has been as for
some unknown reason the files I'm moving back and forth arent
overwritting .. oh well found a way around that.

On 5/3/05, Joshua Olson <joshua at waetech.com> wrote:
> > -----Original Message-----
> > From: Dan McCullough
> > Sent: Monday, May 02, 2005 3:02 PM
> 
> > Guess what?  Its SLOWWWWWWWWWWWWWWWWWWWW!
> > :) Not surprised by that.  So what I am looking for is some advice to
> > speed it up, and possibly add in some smarts.
> >
> > Here is the query.
> > select * from search_string where lower(searchstring) like
> > '%"+searchTerm+"%'
> 
> Dan,
> 
> One quick thought here... the call to Lower probably is not necessary.
> Generally speaking, the LIKE comparison is going to be case insensitive.
> Removing the call to Lower will unnecessitate (new word?) the strong
> operation over every row in the table.
> 
> <><><><><><><><><><>
> Joshua L. Olson
> WAE Tech Inc.
> http://www.waetech.com/
> Phone: 706.210.0168
> 
> Monitor bandwidth usage on IIS6 in real-time:
> http://www.waetech.com/services/iisbm/
> 
>