Re: PaginatedList question

2005-06-30 Thread Aladin
t link). Will it be possible for you to email me the code snippet? That will be of great help. Also how is the performance? Thanks, Satish -Original Message- From: Aladin [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 12:12 AM To: user-java@ibatis.apache.org Subject: Re:

Re: PaginatedList question

2005-06-29 Thread Aladin
Thanks for the response Clinton. Since the last post, I have implemented my system using the queryForList() and am managing my pages using an index & offset. Take care. Aladin Clinton Begin wrote: Hi Aladin, PaginatedList is meant for simple systems that have the luxury of keeping a page

Re: PaginatedList question

2005-06-29 Thread Clinton Begin
Hi Aladin, PaginatedList is meant for simple systems that have the luxury of keeping a page of data around in memory.  In a high performance system that needs to scale, keeping even a page of records in memory is a bad idea...regardless of PaginatedList.  Even 25 records per page could be devastat

Re: PaginatedList question

2005-06-28 Thread ibatis
Hi Clinton, I'm interested in knowing why you would discourage the use of the paginated list in a "high performance" system? In response to another post... In order to compute the number of pages (using the paginatedlist), a simple binary search method can be applied once when the result is firs

Re: PaginatedList question

2005-06-28 Thread Larry Meadors
Could you add your experience with this to the WIKI? Something in the FAQ re: "How do I get record/page counts for a mapped statement?" would be great. Larry On 6/28/05, Aladin <[EMAIL PROTECTED]> wrote: > Hi, > > Thanks for the responses. It's unfortunate that the documentation was > wrong..

Re: PaginatedList question

2005-06-28 Thread Aladin
Hi, Thanks for the responses. It's unfortunate that the documentation was wrong... because that would have been a nice way of getting a general idea as to the number of pages in the set. Aladin Clinton Begin wrote: The documentation is mistaken. Previous() should not wrap for the pagin

Re: PaginatedList question

2005-06-27 Thread Larry Meadors
On 6/27/05, Clinton Begin <[EMAIL PROTECTED]> wrote: > For high performance systems, you should not use paginated list at > allyou should use queryForList with skip and count parameters. Hmm, I'd say for high performance systems, you should not use paginated list at allyou should use a sto

Re: PaginatedList question

2005-06-27 Thread Clinton Begin
The documentation is mistaken.  Previous() should not wrap for the paginated list.  Regardless, you shouldn't use that approach to calculate the number of pages, you should use a separate count(*) query and divide by page size. For high performance systems, you should not use paginated list at al

Re: PaginatedList question

2005-06-27 Thread Zoran Avtarovski
I had trouble getting the Paginated list stuff working and in the end I used a combination of lazy loading and displaytag which works as expected. Z. > Hello, > > I seem to be having some problem with the PaginatedList. > > When I'm on the first page and I do paginatedList.getPreviousPage(), >

Re: PaginatedList question

2005-06-27 Thread Brice Ruth
I can't answer your question directly, but what I've done (and seen posted here previously) is to use a second 'count' query that you can then use to calculate your total pages. I haven't seen anything else that works well in all situations and doesn't suffer from horrible inefficiency.   Brice  O

PaginatedList question

2005-06-27 Thread ibatis
Hello, I seem to be having some problem with the PaginatedList. When I'm on the first page and I do paginatedList.getPreviousPage(), iBatis doesn't wrap to the last page... as specified in the javadoc. I need this wrapping functionality to compute the total number of pages in the result set. Do