Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS running very slow on new server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS running very slow on new server
  • Date: Wed, 4 Apr 2007 09:15:25 +0200

>
> Solved it finally.
> One little row in the configuration was the reason that this
> script was executing so slow.
>
> If anyone of you stumble upon the same trouble, make sure the line
>
> initial block size = 512
>
> is
>
> ; initial block size = 512
>
> cheers
>
> /Magnus
>

Add some note to userguide

diff -u -1 -0 -r1.98 userguide.sgml
--- doc/userguide.sgml 2 Apr 2007 15:06:37 -0000 1.98
+++ doc/userguide.sgml 4 Apr 2007 07:12:05 -0000
@@ -3038,20 +3038,24 @@
</listitem>
<listitem>
<para>DNS. If connecting to the server takes 30 seconds
or 1 minute, you could do worse than to check your
<filename>resolv.conf</>. Use <command>host</> or <command>nslookup</>
to confirm that <productname>FreeTDS</productname> can actually resolve
the name/address you provided in <filename>freetds.conf</>. Give
particular attention to reverse DNS lookups, if you were forced (or
thought you were forced) to identify the server by number, instead of by
name, as Vint intended. You can defeat
<productname>FreeTDS</productname>'s automatic reverse-DNS lookup
feature by inserting
<programlisting>
#define NOREVERSELOOKUPS
</programlisting>
in <filename>src/tds/config.c</>, rebuilding, and reinstalling.
<Note><para> Reverse lookup code has been removed as of version 0.62
due to wrong implementation.</para></Note>
</para>
</listitem>
+ <listitem>
+ <para>Packet size. Check packet size setting on
<filename>freetds.conf</> (see <literal>initial block size</>). Default
value (no configuration) is usually fine. The slowness is due to
multiple packet to use.
+ Under <productname><acronym>GNU</>/Linux</productname>
system we use an optimization to reduce network traffic so you shouldn't
see much difference using this system. </para>
+ </listitem>
</itemizedlist>


</sect1>
</chapter>
<chapter id="help">
<title>Getting Help</title>
<epigraph>
<attribution>Beatles</>
<para><literallayout>

freddy77





Archive powered by MHonArc 2.6.24.

Top of Page