tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Allistair Crossley" <Allistair.Cross...@QAS.com>
Subject RE: [OFF-TOPIC] RE: Is there a way to set the size of ResultSet from MS SQL Serve r
Date Fri, 20 Aug 2004 08:07:30 GMT
jTDS is the fastest driver for SQL Server. We use it for some heavy traffic and found it faster
than the MS driver. 

Allistair Crossley

> -----Original Message-----
> From: Brad McEvoy [mailto:bradmc@massive.com.au]
> Sent: 20 August 2004 01:17
> To: 'Tomcat Users List'
> Subject: [OFF-TOPIC] RE: Is there a way to set the size of ResultSet
> from MS SQL Serve r
> 
> 
> 
> 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:john.villar@florhard.com]
> 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,ResultSe
> t.CONCUR_READ_
> O
> >NLY);
> >pstmt.setFetchSize(100);
> >ResultSet rs = pstmt.executeQuery();
> >...
> >
> >
> >-----Original Message-----
> >From: QM [mailto:qm300@brandxdev.net]
> >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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> 


<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE> 
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href="http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message