Re: Java Client

I can only speak to my swing experience. I'm mid-way through building a Cayenne backed swing app and its been really smooth sailing. Not sure how to answer your questions more specifically around that, are you having troubles? John- On 6/26/07, Florijan Stamenkovic <[EMAIL PROTECTED]> wrote: Hi

Re: paged query slow when fetching big lists

Hi Andrus ! The fix you committed today works great, I can confirm, in our case the 30-50 second SelectQuery now executes in 5-7 seconds ! There is one but: fix does work only for queries executed on server, when I executed the query on (ROP) client, the query takes the same amount of tim

Re: paged query slow when fetching big lists

Hi Marcin, I have good news (I think). Fetching just id columns inside the IncrementalFaultList indeed speeds things up significantly. I just committed the change to optimize SelectQueries to do just that. Please let me know how does it work for you. Now the profiling details... * I prof

Exception: No property for arcId

Hello all. I am getting the CayenneRuntimeException below when trying to invoke the setToOneTarget on one of my generated classes. The _Req and _DepartmentPrefix classes are generated classes. This same code worked yesterday morning but after some updates to the database and subsequent updates to

Java Client

Hi everyone, I am a WebObjects user, and since the future of Java Client support in the WebObjects suite is not certain, I would appreciate some insight into the following: 1. Are there many people using Java Clients with Cayenne? 2. How do the users of it see the effort / results proporti

Re: paged query slow when fetching big lists

Hi Andrus ! Many thanks for that ! Marcin On 26/06/2007, at 5:39 PM, Andrus Adamchik wrote: Hi Marcin, 1) SelectQuery(Student.class) with page size 10 takes 30-50 seconds. 2) SQLTemplate(Student.class, "SELECT #result('id' 'int') from STUDENT") without paging takes 100 sec. 3) SQLTemplate(S

Re: paged query slow when fetching big lists

Hi Marcin, 1) SelectQuery(Student.class) with page size 10 takes 30-50 seconds. 2) SQLTemplate(Student.class, "SELECT #result('id' 'int') from STUDENT") without paging takes 100 sec. 3) SQLTemplate(Student.class, "SELECT #result('id' 'int') from STUDENT") with page size 10 takes 5 sec. 4) SQ