freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: "Gad Hayisraeli" <gadh AT vmanage.com>
To: "FreeTDS List" <freetds AT lists.ibiblio.org>
Subject: [freetds] freetds is very,very slow when "insert into" sybase 12.5
Date: Thu, 30 Jan 2003 10:41:10 +0200

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

Gad

[freetds] freetds is very,very slow when "insert into" sybase 12.5, Gad Hayisraeli, 01/30/2003