Search on Date taking too long.

Post Reply
pbengeri
Posts: 3
Joined: Wed Feb 04, 2004 7:45 pm

Search on Date taking too long.

Post by pbengeri »

Hi,
I have a table which contains a column of data type date,
and I have created an inverted index created on it (as I wanted to use order by clause on this column). There are around 45,000 records in this table.

When I fire a query from tsql:
select ID from tDocs where DateModified >= 'begin of 2003-8' and DateModified <= 'end of 2003-8'

I have also tried out giving the UTC date(no. of seconds after 1-1-1970):

select ID from tDocs where DateModified >= 1062374400 and DateModified <= 1064966400

It takes almost 25 mins to return me the results.

When I give some other date range, i get the results after around 10 sec. but there situations like Aug, 2003 (the above case) where texis takes too long a time.

Is there some know issue with Date predicates.
Or am I doing something wrong.

I am using
Texis Version 03.01.992447526(20010613) Copyright (c) 1988-2001 Thunderstone EPI
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Search on Date taking too long.

Post by mark »

Create a regular index on the field.
pbengeri
Posts: 3
Joined: Wed Feb 04, 2004 7:45 pm

Search on Date taking too long.

Post by pbengeri »

Thanks Mark. That worked.
I had thought that inverted index would be used while doing search as well as while doing order by.
Post Reply