Remember that caching performance behaves like the gauss bell, it has an
optimal point where the performance is top notch, but variating from
there begins to affect the performance..... to keep it simple, too much
nor too little isn't good.... you have to have the *right* quantity of cache
Out of curiosity I profiled the difference setFetchSize makes. Set to 100 on
Oracle it improves the time to iterate over 1000 records by 5-10% compared
to not using it at all, and actually slows it down by that much if a large
fetch size (>1000) is set. This surprised me because i first started using
this on a project with sql server with the native driver and it made a huge
improvement
-----Original Message-----
From: John Villar [mailto:[EMAIL PROTECTED]
Sent: Thursday, 19 August 2004 10:26 PM
To: Tomcat Users List
Subject: Re: Is there a way to set the size of ResultSet from MS SQL
Serve r
However, that would work only if the driver you're using uses the
FetchSize as a hint for caching records. In JDBC caching is primarily
the responsability of the Driver.
Brad McEvoy escribi�:
something like this should do the trick
...
PreparedStatement pstmt =
con.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_
O
NLY);
pstmt.setFetchSize(100);
ResultSet rs = pstmt.executeQuery();
...
-----Original Message-----
From: QM [mailto:[EMAIL PROTECTED]
Sent: Thursday, 19 August 2004 2:04 PM
To: Tomcat Users List
Subject: Re: Is there a way to set the size of ResultSet from MS SQL
Server
On Wed, Aug 18, 2004 at 04:50:32PM -0700, Daxin Zuo wrote:
: I use JDBC in JSP/Java with MS SQL Server.
: Is there a way to set the Fetch Size (set to 10, 100,..) of ResultSet (as
: ADO CacheSize in ASP)?
This sounds like a configuration specific to your database, either with
a custom SQL statement (a la HSQLDB) or with a JDBC URL param...
Unless you mean you want to limit the results using the clause
"LIMIT x" in your SQL.
-QM
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
