FreeTDS Development Group

["Gad Hayisraeli" <gadh AT vmanage.com>]

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