Skip to Content.
Sympa Menu

freetds - Re: [freetds] ODBC.ini parameter in FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sebastien FLAESCH <sf AT 4js.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] ODBC.ini parameter in FreeTDS
  • Date: Sat, 03 May 2008 08:51:31 +0200

James K. Lowden wrote:
Rajesh Akolu wrote:
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 looking for parameters which can increase the performance

You're looking for magic pixie dust to "increase performance" while
providing no evidence for the notion that performance can be increased. You seem to assume it can be, but why? In a database application,
bottlenecks don't show up in the network layer until the server and client
are running at top speed.
You can't manage what you don't measure. Instead of asking the Internet
for random tuning suggestions, monitor your application and discover where
the delays are. Then address yourself to those areas. You'll have the
satisfaction of learning something and doing the job right. And,
possibly, of increasing performance.
--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

Rajesh,

With the native MDAC and SNAC drivers of SQL Server, we got very good
performance improvements by using array fetch (SQL_ATTR_ROW_ARRAY_SIZE).

I am not quite sure if using array fetch makes a difference with FreeTDS,
but so far we use it as it was really efficient with the native drivers.

Note that we are not using the default cursor: we use server-side cursors.

Cheers,
Seb




Archive powered by MHonArc 2.6.24.

Top of Page