hi,
i think that its not a good idea to store your vector into a session. Since
vectors are already very heavy and storing them in the session will only
hamper your performance. i think that its better to fetch the records from
the database in which only the count of the number of records changes
ex: select name from exTable where first = 1 to end = 10;
and the training which i have attended of DBA over there i was told that
database does caching if your query remains the same and only the parameters
change. to further increase your perforamnce you could your
PreparedStatement rather than Statement.
But i would not like the idea of storing your records in a vector and then
in a session.
Correct me if i am wrong
Vikramjit singh,
eAngel Team,
Global Tele-systems Ltd.
Ph. 7612929-3140
-----Original Message-----
From: Mohan Kumar Chintala [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 7:19 AM
To: [EMAIL PROTECTED]
Subject: Re: How to set the PageSize in JSP ???
Hi Wong,
There is a work around for this problem. U can fetch only the
required records from the database. U need to maintain the lowerbound or
higherbound and calculate the other. You can store the Lower or Upper bound
as a hidden varibale in your JSP Page. Use the following SQL. Replace the
string "Your Query Comes here" and supply the HigherBound and LowerBound. It
will fetch u the correct Results.
SELECT *
FROM ( SELECT a.*, rownum r
FROM ( Your Query Comes here ) a
WHERE rownum <= :HigherBound )
WHERE r >= :LowerBound
-Mohan.
-----Original Message-----
From: Dick Wong [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 12:03 PM
To: [EMAIL PROTECTED]
Subject: How to set the PageSize in JSP ???
Dear all,
As I know that there is something like "PageSize" in asp to control how
many records to be retrieve in each page. How can I implement it on JSP ??
Any PageSize in JSP ?? As I want to do a result page with 10 records per
page.
Thanks for your help.
Regards,
Dick Wong
===========================================================================
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
