Thanks for the answer. However we don't have strong performance issue (for now) and it that case, how do you face query where time part is missing ?
On Tue, Sep 8, 2009 at 17:44, Silent Surfer <silentsurfe...@yahoo.com>wrote: > Hi, > > If you are still not went live already, I would suggest to use the long > instead of date field. According to our testing, search based on date fields > are very slow when compared to search based on long field. > > You can use System.getTimeInMillis() to get the time > When showing it to the user, apply a date formatter. > > When taking input from user, let him enter whatever the date he wants to > and then you can convert to "long" and do your searches based on it. > > Experts can pitch in with any other ideas.. > > Thanks, > sS >
