cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Paging in web application
Date Wed, 02 Apr 2008 10:10:36 GMT
Hi Malcolm,

Here they are:

(3.0M1) https://issues.apache.org/cayenne/browse/CAY-810
(3.0M4, unreleased) https://issues.apache.org/cayenne/browse/CAY-999

There are also a few other jiras that dealt with proper caching  
support for paginated lists.

Andrus


On Apr 2, 2008, at 12:59 PM, Malcolm Edgar wrote:

> What were the big paging performance improvements in 3.0?
>
> regards Malcolm Edgar
>
> On Wed, Apr 2, 2008 at 7:27 PM, Robert Zeigler <robertz@puregumption.com 
> > wrote:
>> Typically, you're just going to use a paginated query:
>> SelectQuery q = new SelectQuery(Artist.class);
>> q.setPageSize(50);//triggers the pagination.
>>
>> You can get the size of the result set without faulting every (or  
>> any)
>> object in it, jump to specific objects w/in the query (and only  
>> fault the
>> "neighboring" objects on the same page), etc.
>> This works well for most things.  With the recent performances  
>> improvements
>> in 3.0, this works wonderfully for a large portion of use cases out  
>> there.
>> You can also use setFetchLimit to limit the # of results returned.
>> Unfortunately, there's no corresponding "setOffset" method.  But  
>> you can
>> use SQLTemplate to accomplish the task, if you really need it.
>>
>> Robert
>>
>>
>>
>> On Apr 2, 2008, at 4/22:49 AM , John Emmanuel wrote:
>>
>>> Hi,
>>>
>>> Is there a best practice for paging in a web application.
>>> If so, can somebody please direct me to a demo/article/tutorial.
>>>
>>> If none is available could somebody  just briefly tell me how
>>> they incorporated paging in a production webapp.
>>>
>>> I have read the documentation (which provides examples
>>> of paging in desktop apps), have gone through the
>>> petstore example (which uses ibatis PaginatedList (which btw has
>>> now been deprecated), but am not clear about the best way
>>> to go about it.
>>>
>>> regards,
>>> John Emmanuel
>>>
>>
>>
>


Mime
View raw message