freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] FreeTDS running very slow on new server
- 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
-
[freetds] FreeTDS running very slow on new server,
Magnus Palm, 04/02/2007
-
Re: [freetds] FreeTDS running very slow on new server,
Magnus Palm, 04/03/2007
- Re: [freetds] FreeTDS running very slow on new server, ZIGLIO, Frediano, VF-IT, 04/04/2007
-
Re: [freetds] FreeTDS running very slow on new server,
Magnus Palm, 04/03/2007
Archive powered by MHonArc 2.6.24.