[KinoSearch] Sorting by date
marvin at rectangular.com
Thu Jan 7 08:09:12 PST 2010
On Thu, Jan 07, 2010 at 01:43:20PM +0000, Dermot wrote:
> My dates are currently stored in UTC format, 2010-01-05T00:00:00. Are
> you saying that I should convert them (before indexing) to
> "YYYY-MM-DD HH:MM:SS", EG s/T/ /, and store them as a StringType and
> the SortRule will work?
UTC format should sort correctly without editing. Store as a StringType and
it should work.
> I am currently using StringType for integers and sorting them which
> appears to be working fine. I'd assumed it would also work with
> timestamps too.
> I'm using 0.30_071 which has the test your referring to. Should I switch to
> Int*Type for my integers?
It's not that big a deal. Using an integer type for sorting will produce sort
cache files that take up slightly less space. Search-time performance
differences ashould be negligible. If index size is important to you, you
might consider switching.
More information about the kinosearch