[KinoSearch] Sorting by date

[Marvin Humphrey]

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. 

Yes.

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

Marvin Humphrey