ODBC.ini parameter in FreeTDS

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



[email protected] 

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.

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds