[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] ic 4.8.3 foundation - speeding searches
> > 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
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/