[freetds] ODBC.ini parameter in FreeTDS

Rajesh Akolu rajesh.akolu at ftindia.com
Fri May 2 02:05:26 EDT 2008


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 



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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 5161 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080502/3fd69c26/attachment.jpe 

More information about the FreeTDS mailing list