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
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