Texis OR search slow!!
Posted: 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!!
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!!