IMHO, this is an excellent article on TheServerSide.com "Data List Handler: A Pattern for Large Search Result Sets"
http://www.theserverside.com/resources/article.jsp?l=DataListHandler -- Andrew Kuzmin http://www.java201.com ----- Original Message ----- From: "Michael Muller" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, September 16, 2003 8:27 PM Subject: Re: Multipage JDBC result > > I read the documentation, but I can't tell what the pager iterates over. > I'm assuming it iterates over java collections. > > This could be a problem if you have a huge result set. Another option > would be to use database features like mysql's "select * from foo limit > 50 offset 250" syntax. It's still a lotta work for the database if > there's a huge result set, but a lot easier on the web app. > > -- Mike > > Andrew Kuzmin wrote: > > > Hi, > > > > see this link > > http://jakarta.apache.org/struts/faqs/newbie.html#pager > > > > -- > > Andrew Kuzmin > > http://www.java201.com > > > > ----- Original Message ----- > > From: "Jonathan Hawkins" <[EMAIL PROTECTED]> > > To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > > Sent: Tuesday, September 16, 2003 3:39 PM > > Subject: Multipage JDBC result > > > > > > > >>Howdy, > >>Any tips as to where I can find code examples of how to break down a > >>large JDBC result > >>into say 25 rows per page? > >> > >> > >>Jon Hawkins > >> > >> > >>--------------------------------------------------------------------- > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
