Ran into a similar problem with MySQL database. I used the limit clause with the select statement and it was the most efficient solution for me. Select * from ____ where ____ limit 50 Gunjan > ---------- > From: Vincenzo Scervo[SMTP:[EMAIL PROTECTED]] > Reply To: Vincenzo Scervo > Sent: Wednesday, August 30, 2000 11:07 AM > To: > Subject: I: Distribute query result in multiple pages > > Hi, > I am facing a problem to manage query result and split them in more than > one > page. > I have a jsp page where the user can insert research parameters and submit > the query. Then the Jsp page show all the rows extracted from the db. > But How to show all the record when they are thousands? > The natural answer is just to use multiple pages and to show about 50 rows > at a time. > > I wonder if some of you already faced the problem. I thought several > possibility, but they don't look so good. > > I can use a query that extracts only a portion of my data each time. But > in > that way I run a lot of query on the DBMS. > I can use a stateful session bean to hold a connection, opena cursor and > fetch the data as I need them. But I don't want to create so much session > bean (I expect at least 1000 user, and the application is full of research > page). > I can still use a stateless session bean and extract all the data I need > and > store them (let's say in a collection) and then use them as I need. But > what > happens when the records are millions (it could anyway happen). > > I will really appreciate your help. > Regards. > > VIncenzo Scervo. > > ========================================================================== > = > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.html > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
