[ic] ic 4.8.3 foundation - speeding searches

Mike Heins interchange-users@interchange.redhat.com
Fri Feb 15 13:14:00 2002


Quoting DB (DB@m-and-d.com):
> Searches on the "sku" field, which I know is indexed, don't seem any
> faster than searches on the un-indexed "comment" field. Does this mean
> my searches are already going about as fast as possible? Each takes
> about 3-4 seconds which is not bad.
> 
>  > Also: IC Database Docs : 4.2 Glimpse IC Database Docs : 4.3 Fast
>  > Binary Search
> 
> Fast binary wouldn't appear to be of use since it matches only the
> beginning of a line. Glimpse looks promising but the documentation is a
> little lean. But I'll give it a shot. Is it likely to help or should I
> settle for 3-4 seconds?

3-4 seconds is awful unless you are on a 90MHz pentium. 8-) Of course
we don't know how much of that is page build speed and how much
is search speed. Try building a results page of:

    [search-region]
	[search-list]
	    [item-code]
	[/search-list]
    [/search-region]

Run the search against that and you will see how long it is
really taking. If it is more than 1 second, you should 
produce a two-field file (sku/comment) and search that with
the text search. 

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

"Even if you're on the right track, you'll get run over if you just
sit there." -- Will Rogers