I am using websphere application server. Is there any way so that data can
be cached on application server.
Other way what is the mechanism in search engines like yahoo or google so
that they are showing 30 record per page out of some thousands of records
retrived.
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Nishit Trivedi
Sent: Thursday, April 12, 2001 5:49 PM
To: [EMAIL PROTECTED]
Subject: Re: Caching problem
I don't get it.
These are two conflicting statements you are having:
1."But i dont want to retrive all record at the same time
sothat it will take a lot of time for the first time."
2. "also not want to
connect to dastabase for each request for next 25 records."
Question are:
1.How can you get another 25 without connecting AGAIN to db..???
2.And how you are going to keep track which one was selected at
first time and which ones are not...??? (unless you want to delete records
from db as soon as they are selected)
But here is what i think :
You can use session for it...
Get all result from db at a shot and store it in an array (well if you dont
know exactly how many records are there then first store it in vector and
then convert that vector into array)
Now store that array in a session..
Now when user selects let's say 1 to 25
records,display records 1 to 25 and so on...
hope this may help you..
Nishit
-----Original Message-----
From: Debasis Dash [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 5:13 PM
To: [EMAIL PROTECTED]
Subject: Caching problem
I am requesting aquery which return 5000 results. But i want to show only 25
record per page. But i dont want to retrive all record at the same time
sothat it will take a lot of time for the first time. also not want to
connect to dastabase for each request for next 25 records. How to build the
caching mechanism for this.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
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".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
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".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
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
