FreeTDS Development Group

["Rajesh Akolu" <rajesh.akolu AT ftindia.com>]

Hi,



We are using FreeTDS 0.64 (TDS version 8.0) and unixODBC 2.2.12 on RH Linux 
3.4.6 and connecting to Microsoft SQL Server 2000 from Linux. We are using 
C++ on Linux. 



We are looking for parameters which can increase the performance, so we used 
"Packetsize" parameter in odbc.ini and set it with different values and 
monitored our application performance. We found no difference.



We have done following tests:



Case 1:

ODBCConfig --> User DSN --> Configure --> "We entered 512 against PacketSize"



Case 2:

We used following connecting string in our code (here we did not specify 
PacketSize using ODBCConfig since we are using the same in connection 
string): "DRIVER=FreeTDS; SERVER=<server name>; DATABASE=pubs; UID=<user 
name>; PWD=<password>; PacketSize=512"



In both the above cases we did not see any performance difference. 



Please suggest thanks in advance.





Thanks & best regards,

Rajesh Akolu

Financial Technologies (India) Ltd.          

Board No: 022-26831022     Extn: 254

Fax: 022-26836999



rajesh.akolu AT ftindia.com 

www.ftindia.com 



Disclaimer:

The information in this E-mail (which includes any files transmitted with it) 
is CONFIDENTIAL and may be legally PRIVILEGED. It is intended solely for the 
addressee and access to this email by anyone else is unauthorized. If you 
have received it in error, please destroy any copies of this message, 
including any attachments, and delete it from your system notifying the 
sender immediately. Any disclosure, copying, distribution, dissemination, 
forwarding, printing or any action taken or omitted to be taken in reliance 
on it or utilising the same for any purpose other than what it is intended 
for, is prohibited and may be unlawful.

Attachment: image001.jpg
Description: JPEG image