Re: [OFF-TOPIC] RE: Is there a way to set the size of ResultSet from MS SQL Serve r

[John Villar]

An issue even more important that speed with jTDS is the fact that it is 
100% Open Source Java Code, and that's something M$ wont let you have. 
The implications of having Open Source Software can be read at the OSI 
web site www.opensource.org and the fact that it's 100% Java implies 
that your webapp can be run everywhere (except, of course,  for the M$ 
SQL Server).

Something off topic, does anyone has wondered why M$ hasn't developed 
its server line for linux? i know the usual response "They want you to 
buy W2K Server", but that would be superficial thinking.... marketing 
issues arise as you measure the volume needed of additional apps that 
you have to install to a W2KS in order to have it working as you 
need.... just my toughts....

Allistair Crossley escribi�:
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]

 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]