Skip to Content.
Sympa Menu

freetds - RE: [freetds] freetds is very,very slow when "insert into" sybase 12.5

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] freetds is very,very slow when "insert into" sybase 12.5
  • Date: Thu, 30 Jan 2003 09:45:06 +0100

>
> my config:
> client : linux RH 6.2 x86, P-III 800 mhz, freetds 0.60, iodbc
> driver manager , tds version 5.0
> data : 26 columns table (mainly strings)
> server : windows , sybase 12.5 ASE.
>
> (windows hardware is the same as linux)
>
> speed : 3.5 lines per second (lps) for "insert into" with parameters.
>
> comparisons:
> =============
> windows,sybase - local (odbc of sybase) : 181 lps
>
>
> linux, mysql 3.23, remote( tcpip,odbc) - 145 lps
>
> so obviously its the tds that slows things down ( by more than x20 ! )
>
> can someone explain why ?
>
> thanks
>

Probably you have logging torned on.
A good comparison is windows remote / linux remote.

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================




Archive powered by MHonArc 2.6.24.

Top of Page