As far as I have encountered the best and simplest option is to use date time as string (yyyymmddHHmmss or yyyymmdd) as per your requirement.
Prabin toostep.com On Tue, Jan 13, 2009 at 2:37 PM, Ganesh <emailg...@yahoo.co.in> wrote: > I am indexing and storing date time with minute resolution. I need to do > date range query and also do sorting on this field. I am having almost 30 > million records spread across 20 database. > > option1: > To index the date time as string > > option2: > To index date, hour and minute separately as number. > > Which option will consume lesser memory? > > Whether date range query will also load all data using FieldImpl? > > Regards > Ganesh > Send instant messages to your online friends http://in.messenger.yahoo.com > --------------------------------------------------------------------- > To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org > For additional commands, e-mail: java-user-h...@lucene.apache.org > >
