Dont load the 1000s of records at once.
Send the data back to the browser in small chunks, maybe 100 rows at a time.
For example, if the user submits a query that matches 3000 rows, only return
the first 100. Provide a 'more' button that progressively gets the next 100
rows.
Basically you need to handle this situation like most of the internet search
engines do - eg yahoo, dejanews.
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Vaibhav Bhanot
Sent: Saturday, December 18, 1999 10:13 PM
To: [EMAIL PROTECTED]
Subject: Large number of records in JSP !!!
Hi All ,
I am in a fix here...could anybody help me out...i am using jsp's
at the client side and ORACLE as the backend...i have got around
thousands of records in some of my tables...now i cannot show all the
records to client if he queries the database...how should i handle this
situation...
vaibhav
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
