Re: Pagination of large database tables

[Paul Iov]

Hi Pallavi! First of all take a look at http://wiki.apache.org/myfaces/WorkingWithLargeTables. The illustrating code there is IMHO a little bit buggy (especially for subsets of large datasets, which commes from EJB it makes no sense to fetch the same page twice, since the sorting order never chahges), but generally this approach works fine. I have exactly the same usecase - large resultsets and fetching on demand, but I'm using ac:AjaxDataScroller insteed of <t:dataScroller>, because the second one is not Ajax-compatible :( Any way, with own extended implementation of DataModel im background it would be preaty easy to implement "fetch more" feature, you are asking for. regards, paul [EMAIL PROTECTED] schrieb: Hi All,   I currently have a requirement for pagination. I want the following GUI display <<1 2 3 4 5 more >>. Where on click of << is for previous. And on click of >> is for next. So with these two i could go ahead with <t:dataScroller> for the above mentioned functionlity. But if i had the advantage of knowing the total number of rows with DB to perform COUNT operation on the total number of rows.   But for larger tables this wouldn't be efficient. Hence the requirement demands fetching rows in multiples of 250. And each page displaying 50 rows per page. With the click on more it would fetch the next 250 rows. And the display should look like << 6 7 8 9 10 More >>.(something similar to google's pagination).   Is there a way by which i can implement this. Or can i extend the functionality of <t:dataScroller> to implement this. Any suggestions are welcome.     Best Regards, Pallavi         The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com