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: "Gad Hayisraeli" <gadh AT vmanage.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] freetds is very,very slow when "insert into" sybase 12.5
  • Date: Mon, 3 Feb 2003 18:38:51 +0200

ok ,

>
> Gad, you are interested in testing performance but you should give more
> information to reproduce your test and help you solving this problem.
> I briefly compared ms odbc driver with freetds one (CVS version) and I
> haven't seen much difference.
>
> What library do you use?
> What FreeTDS version? 0.60 have a problem with default logging setting...
> What server do you use?
> What FreeTDS configuration are you using?
> Can you provide test code?
> You speaks about "insert into" but how use insert into? Do you construct
> yourself statement or not?
> You should try speed from different machine even or never (or server <->
> client locally or server <-> client remote, not local for win <-> win and
> remote for win <-> linux).
>
> freddy77
>


application : private (uses odbc 3 api , see below) - uses only create table
and insert into (see below)
odbc upper layer (api that i use) : odbc++ 0.22
odbc driver manager : iodbc 3.0.5
odbc driver : freetds 0.60
client platform : linux i686 x86 , p-III 800 mhz, 256 mhz ram
server platform : windows 2000 pro , P-III 800 mhz , 392 mb ram
server db : ASE eval for windows nt , version 12.5

freetds config:
================================
[global]

tds version = 5.0

initial block size = 512

swap broken dates = no

swap broken money = no

try server login = yes
try domain login = no

cross domain login = no


[sybase]
host = 10.0.0.25
port = 4000
tds version = 5.0

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

odbc.ini config:
==================
[sybase]
Driver=/home/apps/vnms/lib/libtdsodbc.so
Description=Sybase Server at imc_server
Trace=No
Servername=sybase
Database=perfmona
UID=sa
PWD=......

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

local win to win performace - 180 LPS (lines per second)

CREATE TABLE std_ether_stats ( dataSourceIpAddr VARCHAR(255) NULL , dateTime
VARCHAR(255)
NULL , ifAdminStatus NUMERIC NULL , ifDescr VARCHAR(255) NULL , ifInDiscards
NUMERIC NULL , ifInErrors NUMERIC NULL , if
InNUcastPkts NUMERIC NULL , ifInOctets NUMERIC NULL , ifInUcastPkts NUMERIC
NULL , ifInUnknownProtos NUMERIC NULL , ifIn
dex NUMERIC NULL , ifLastChange NUMERIC NULL , ifMtu NUMERIC NULL ,
ifOperStatus NUMERIC NULL , ifOutDiscards NUMERIC NU
LL , ifOutErrors NUMERIC NULL , ifOutNUcastPkts NUMERIC NULL , ifOutOctets
NUMERIC NULL , ifOutQLen NUMERIC NULL , ifOut
UcastPkts NUMERIC NULL , ifPhysAddress VARCHAR(255) NULL , ifSpecific
VARCHAR(255) NULL , ifSpeed NUMERIC NULL , ifType
NUMERIC NULL , osoMediatorIpAddr VARCHAR(255) NULL , sysUpTime NUMERIC NULL )


and "insert into" is with parameters




thanks to you all


Gad







Archive powered by MHonArc 2.6.24.

Top of Page