Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 61743 invoked from network); 2 Apr 2008 10:11:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Apr 2008 10:11:09 -0000 Received: (qmail 3303 invoked by uid 500); 2 Apr 2008 10:11:08 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 3285 invoked by uid 500); 2 Apr 2008 10:11:08 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 3276 invoked by uid 99); 2 Apr 2008 10:11:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Apr 2008 03:11:08 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [208.78.103.231] (HELO vorsha.objectstyle.org) (208.78.103.231) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 02 Apr 2008 10:10:27 +0000 Received: (qmail 30212 invoked from network); 2 Apr 2008 10:10:38 -0000 Received: from unknown (HELO ?IPv6:::1?) (127.0.0.1) by localhost with SMTP; 2 Apr 2008 10:10:38 -0000 Message-Id: From: Andrus Adamchik To: user@cayenne.apache.org In-Reply-To: <525d8e10804020259n598d9169j9100aa28d7745dad@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: Paging in web application Date: Wed, 2 Apr 2008 13:10:36 +0300 References: <329BCE0D-DE45-4876-9E17-6C07039E3220@puregumption.com> <525d8e10804020259n598d9169j9100aa28d7745dad@mail.gmail.com> X-Mailer: Apple Mail (2.919.2) X-Virus-Checked: Checked by ClamAV on apache.org 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 > 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 >>> >> >> >