thats true, but now i think about it, why would anyone use the JDBC driver to connect to SQL Server? The JDBC driver is the worst one i've used and the MS native driver is probably the best.
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]
