Skip to Content.
Sympa Menu

freetds - [freetds] ODBC.ini parameter in FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rajesh Akolu" <rajesh.akolu AT ftindia.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] ODBC.ini parameter in FreeTDS
  • Date: Fri, 2 May 2008 11:35:26 +0530


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




Archive powered by MHonArc 2.6.24.

Top of Page