Skip to Content.
Sympa Menu

freetds - [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: "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

Archive powered by MHonArc 2.6.24.

Top of Page