FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

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