All, I have indexed due_date and account and got much better performance already.
I don't really want to split the date into 1 or 2 ints. I use Hibernate and I want to maximize GregorianCalendar. I need to perform complex date operations I don't want to rewrite this functions. I rely heavily on Criteria and Projection. Joebert _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph

