Caching a Resultset 2005-02-08 - By Kalra, Ashwani
Back
Do not fetch all the records from DB. Fetch certain no of records and cache
them. When user hits next button and the record is not there, hit the
database again and fetch the records again. In my application I am caching 5
pages of records. This incluldes 1 page backward , 1 current page and 3
forward pages. I keep on moving this window as user progresses to the next
page and when he hits the page which is not in cache.
/ Ashwani
-- --Original Message-- --
From: Sanjeev K.R [mailto:sanjeevkoppal@(protected)]
Sent: Tuesday, February 08, 2005 3:24 PM
To: J2EE-INTEREST@(protected)
Subject: Caching a Resultset
Hi,
We have around 20000 - 40000 of record in a table,
We are using JSP and a front controller(Servlet) and some DAO's
We have implemented Pagination also....
We have a performance set back,we are displaying 10 record at a time in a
page,
We are using the absolute potion of the ResultSet to fetch the next 10
records,
can anyone help me in achiving a better performance,
I cannot built all the 20000 objects at the same time in my DAO,
How can i cache the result set? or the query.....
My code goes some thing like this...
[
DBConnection dbConn = manager.getConnection();
Statement stmt =
dbConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_RE
AD_ONLY);
EnquireMaintainOrderVO enquireOrder=((EnquireMaintainOrderVO)query);
ResultSet rs = stmt.executeQuery(getQuery(enquireOrder));
rs.absolute(((Integer)param).intValue());
]
Please can anyone throw some light on this ASAP..
Thanks & regards
Sanjeev
__ __
Do you Yahoo!?
Yahoo!
<http://us.rd.yahoo.com/mail_us/taglines/security/*http://promotions.yahoo.c
om/new_mail/static/protection.html> Mail - You care about security. So do
we.
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
This message contains information that may be privileged or confidential and is
the property of the Capgemini Group. It is intended only for the person to whom
it is addressed. If you are not the intended recipient, you are not authorized
to read, print, retain, copy, disseminate, distribute, or use this message or
any part thereof. If you receive this message in error, please notify the
sender immediately and delete all copies of this message.
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859 (See http://ISO-8859.ora-code.com)-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=922401615-08022005><FONT face=Arial color=#0000ff size=2>Do not
fetch all the records from DB. Fetch certain no of records and cache them. When
user hits next button and the record is not there, hit the database again and
fetch the records again. In my application I am caching 5 pages of records. This
incluldes 1 page backward , 1 current page and 3 forward pages. I keep on moving
this window as user progresses to the next page and when he hits the page
which is not in cache.</FONT></SPAN></DIV>
<DIV><SPAN class=922401615-08022005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><B><FONT face="Arial Narrow"><SPAN
class=922401615-08022005>/</SPAN> Ashwani</FONT></B></DIV>
<P><STRONG><FONT face="Arial Narrow"></FONT></STRONG><STRONG><FONT
face="Arial Narrow"></FONT></STRONG><STRONG><FONT
face="Arial Narrow"></FONT></STRONG><STRONG><FONT
face="Arial Narrow"></FONT></STRONG><STRONG><FONT
face="Arial Narrow"></FONT></STRONG><BR> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-- --Original Message-- --<BR><B>From:</B> Sanjeev K.R
[mailto:sanjeevkoppal@(protected)]<BR><B>Sent:</B> Tuesday, February 08, 2005
3:24 PM<BR><B>To:</B> J2EE-INTEREST@(protected)<BR><B>Subject:</B> Caching a
Resultset<BR><BR></FONT></DIV>
<DIV>Hi,</DIV>
<DIV>We have around 20000 - 40000 of record in a table,</DIV>
<DIV>We are using JSP and a front controller(Servlet) and some DAO's</DIV>
<DIV>We have implemented Pagination also....</DIV>
<DIV>We have a performance set back,we are displaying 10 record at a time in a
page,</DIV>
<DIV>We are using the absolute potion of the ResultSet to fetch the next 10
records,</DIV>
<DIV>can anyone help me in achiving a better performance,</DIV>
<DIV>I cannot built all the 20000 objects at the same time in my DAO,</DIV>
<DIV>How can i cache the result set? or the query.....</DIV>
<DIV>My code goes some thing like this...</DIV>
<DIV>[</DIV>
<DIV><FONT size=2>DBConnection dbConn = manager.getConnection(); </FONT></DIV>
<DIV><FONT size=2>Statement stmt =
dbConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR
_READ_ONLY);</FONT></DIV>
<DIV><FONT size=2>EnquireMaintainOrderVO
enquireOrder=((EnquireMaintainOrderVO)query);</FONT></DIV>
<DIV><FONT size=2>ResultSet rs =
stmt.executeQuery(getQuery(enquireOrder));</FONT></DIV>
<DIV><FONT size=2>rs.absolute(((Integer)param).intValue());</DIV></FONT>
<DIV>]</DIV>
<DIV>Please can anyone throw some light on this ASAP..</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Thanks & regards</DIV>
<DIV>Sanjeev</DIV>
<DIV> </DIV>
<P>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/mail_us/taglines/security/*http://promotions
.yahoo.com/new_mail/static/protection.html">Yahoo!
Mail</A> - You care about security. So do we.
=========================================================================== To
unsubscribe, send email to listserv@(protected) and include in the body of
the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
<P></P></BLOCKQUOTE></BODY></HTML>
<table><tr><td bgcolor=#ffffff><font color=#000000>This message contains
information that may be privileged or confidential and is the property of the
Capgemini Group. It is intended only for the person to whom it is addressed. If
you are not the intended recipient, you are not authorized to read, print,
retain, copy, disseminate, distribute, or use this message or any part thereof
. If you receive this message in error, please notify the sender immediately
and delete all copies of this message.<br>
<br>
</font></td></tr></table>
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
<p>
|
|
