Skip to Content.
Sympa Menu

freetds - Re: [freetds] Performace

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Performace
  • Date: Thu, 13 Feb 2003 00:06:18 -0500

On 12 Feb 2003 09:44:24 +0100, Frank von Daak <frank.fun AT kpage.de> wrote:
>
> This table has about 350 records with one TEXT-Field.
> The TEXT-Field inherits text like '_100__112_115__201__...' (max.
> 200-300 Chars). The other fields are VARCHARs and INTs...
>
> I just want to know, if there are some flags, that I can set, to
> increase the performance - or do I have to do this with workarounds in
> my application ?

There was a thread recently on this topic. You might want to try changing


initial block size = 512

in freetds.conf to something bigger, say, 2048 or 4096.

Please let us know if that makes a difference for you.

--jkl





Archive powered by MHonArc 2.6.24.

Top of Page