Re: paginated queries, setPageSize

2011-04-05 Thread Korbinian Bachl - privat
e added to the discussion below: http://cayenne.195.n3.nabble.com/paginated-queries-setPageSize-tp2779985p2780297.html [2] To unsubscribe from paginated queries, setPageSize, click here [3]. Links: -- [1] http://www.zylin.com/zy1000.html [2] http://cayenne.195.n3.nabble.com/paginated-que

Re: paginated queries, setPageSize

2011-04-05 Thread felix
US toll free 1-866-980-3434 / International +47 51 87 40 27 > > http://www.zylin.com/zy1000.html [1] > ARM7 ARM9 ARM11 XScale Cortex > JTAG debugger and flash programmer > > - > > If you reply to this email, your message will be added to the > discussion

Re: paginated queries, setPageSize

2011-04-05 Thread Øyvind Harboe
Hi Felix, I've implemented paged queries using Cayenne and Wicket. As I recall you have to implement a "dataprovider" that will run the query every time the page is rendered. The objects that are serialized into the page must be small (per design). The dataprovider implements sorted, paged queri

Re: paginated queries, setPageSize

2011-04-05 Thread felix
>> INFO  - QueryLogger                - SELECT t0.ProposalID, > t0.ProposalTS, >> t0.CompanyFK, t0 FROM Proposal t0 WHERE (t0.ProposalID = ?) OR >> (t0.ProposalID = ?)... - prepared in 30 ms. >> INFO  - QueryLogger                - === returned 1006 > rows. - took 130 ms

Re: paginated queries, setPageSize

2011-04-05 Thread Andrey Razumovsky
; (t0.ProposalID = ?)... - prepared in 30 ms. > INFO  - QueryLogger                - === returned 1006 rows. - took 130 ms. > INFO  - QueryLogger                - +++ transaction committed. > > I'd appreciate if someone could help me out. > > Thanks > Felix >

paginated queries, setPageSize

2011-04-05 Thread felix
urned 1006 rows. - took 130 ms. INFO - QueryLogger- +++ transaction committed. I'd appreciate if someone could help me out. Thanks Felix -- View this message in context: http://cayenne.195.n3.nabble.com/paginated-queries-setPageSize-tp2779985p2779985.html Sent from the