myfaces-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mikael Andersson" <mail.mi...@gmail.com>
Subject Re: Pagination of large database tables
Date Mon, 19 Feb 2007 11:20:24 GMT
Hi,
you may find some usefull information in the myfaces wiki [1], there are
some pages regarding working with large datatables.

[1] http://wiki.apache.org/myfaces/

Cheers,
 Mike

On 19/02/07, pallavi.roy@wipro.com <pallavi.roy@wipro.com> wrote:
>
>  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
>

Mime
View raw message