Texis OR search slow!!

skalyanaraman · Post by **skalyanaraman** » Mon Aug 04, 2003 7:25 pm

Hi,
I know the using the OR clause to search will slow down the searches. But, we are finding this one very slow.
We are doing a search where,

FIELD1 like 'Andrew' OR FIELD2 like 'FUL'

and the search runs for 15 mins.

But if I run them individually they run in less than 2 minutes. BTW, the second part FIELD2 like 'FUL' returns 0 hits, which is fine. But, still the OR takes a long time.

Any reason why? The database table is around 4GB. not too big. we are using 64-bit texis on UNIX Solaris 8.

Thanks!!

Post by **mark** » Mon Aug 04, 2003 9:06 pm

With proper up to date metamorph inverted indices on each of those fields a search of either should be sub-second under normal circumstances. Make sure you have indices and that they are up to date.

How many rows are returned by the andrew search?

skalyanaraman · Post by **skalyanaraman** » Mon Aug 04, 2003 9:29 pm

Hmm,
I checked,
the indexes seem to be fine on both the fields. The _T, _D are all 62bytes(so no edits).

Indivudually run,
FIELD1 like 'Andrew' gives
count(DOCID)
------------+
140779
0.701s real 0.390s user 0.020s system

FIELD2 like 'FUL' gives
count(DOCID)
------------+
0
0.078s real 0.000s user 0.000s system

But when I run,

FIELD1 like 'Andrew' OR FIELD2 like 'FUL'

It takes a long time.

Post by **mark** » Tue Aug 05, 2003 12:37 pm

In that case it seems to be somewhat overconservative in it's optimizations. If you have maintenance open a tech support ticket to request an update to resolve this issue. It may be available within a week.

skalyanaraman · Post by **skalyanaraman** » Tue Aug 05, 2003 1:12 pm

Thanks
BTW, What is the email for maintenance? How do I contact them?
what are all the info they need?

Post by **mark** » Tue Aug 05, 2003 2:00 pm

Click the tech support link on the left and scroll down to fill in the form.