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:[EMAIL PROTECTED] > 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:[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,ResultSe > t.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] > > <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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
