Re: Converting timestamp to date for queries

2007-06-23 Thread Andrus Adamchik
A DATE logically spans a 24 hour period, so if I understand what you are trying to do, you need a BETWEEN qualifier that spans that range of timestamps from 00:00:00 to 23:59:59 on that date. Andrus On Jun 18, 2007, at 9:44 PM, Kevin Menard wrote: Hi, I've been playing around with dj

Re: paged query slow when fetching big lists

2007-06-23 Thread Andrus Adamchik
You need to use a profiler. You can try an evaluation version of YourKit for example. It has a nice Eclipse plugin, so you can profile straight from Eclipse: http://www.yourkit.com/ (wonder if ASF has a free open source license for YourKit? ObjectStyle does - it was granted to Cayenne

Re: paged query slow when fetching big lists

2007-06-23 Thread Andrus Adamchik
Ari, Marcin -- going through the code I noticed one inefficiency - the elements array access is synchronized in 'fillIn' method. Since 'fillIn' is called from constructor, such synchronization is unneeded and only slows things down. I just checked a fixed version to trunk. Could you try i