[ic] ic 4.8.3 foundation - speeding searches

[Kevin Walsh]

>  > Brev Patterson <bpatters@redhat.com> wrote...
>  >
>  > IC Database Docs : 1.7 Dictionary Indexing with INDEX
> 
> OK Thanks... I tried to create a index on the "comment" field, but
> apparently some additional magic is needed to index a TEXT field. Maybe
> I can simply change the "comment" field to something like VARCHAR(256)
> and then index?
> 
> 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?
> 
As I remember, you are using PostgreSQL as your database.

If I'm right about that, check that you have index created on the
appropriate columns in your database tables.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/