On Thu, 10 Jul 2008 17:55:55 -0600
"Galen Pahlke" <[EMAIL PROTECTED]> wrote:
> Could this perhaps be because a date field has so many possible unique
> values? I don't know how to find out exactly, but I'd guess there are
> at least a few million unique dates in the index. Would increasing the
> granularity of the date field so that there are less unique values likely
> increase
> search speed?
Surely you mean decreasing the granularity... ie, from dates which include
milliseconds , to something like, say, minute, or even seconds, can make a big
difference.
alternatively, what I've done on date fields that need fast searches, is to
convert them at data loading time into a numeric field of the form YYYYMMDD or
YYYYMMDDHHMM . it won't allow you to directly query for NOW - 4 , but you can
do the calculation when preparing the search and obtain the same result.
B
_________________________
{Beto|Norberto|Numard} Meijome
"He has no enemies, but is intensely disliked by his friends."
Oscar Wilde
I speak for myself, not my employer. Contents may be hot. Slippery when wet.
Reading disclaimers makes you go blind. Writing them is worse. You have been
Warned.
