Skip to Content.
Sympa Menu

freetds - [freetds] slow freetds-sybase perfromance - thorough test

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] slow freetds-sybase perfromance - thorough test
  • Date: Wed, 5 Feb 2003 16:03:23 +0200

i could not attach all the files, since there is a 75 k limit ...

before my results , i have a problem : i could not make DataDirect TDS ODBC
driver for Sybase to work under Win32. only
the SYbase ASE odbc driver works. if someone can explain what is this error
(resulted from the DataDirect TDS win32 odbc
driver above) i'll be glad , and i'll have TDS results not only from freetds
but also from other drivers :

"[Merant][ODBC DirectConnect driver] The server info 'DEFAULT_TXN_ISOLATION'
was not found in exec sp_server_info."
and also i cannot figure out what is the "service" setting in this driver as
well.

and now for the test: i used the scroll.cpp test, with some addons (i attach
it here) that is included in odbc++/tests
dir.
on windows - i compiled it against static library of odbc++ , attached too.
used ASE odbc driver and windows driver
manager
on linux - against libodbc++.so , attached also, and iodbc 3.0.5, stlport
4.53 , and freetds 0.60
(change the makefile to suit your dirs)

i attach all the files needed on win32, and most of them in linux , cause the
odbc++ and stlport are big , so you should
build them yourself , or not use stlport at all. (i had to have it because of
other project historical reasons)

some data:

time = average time of 4 tests , only "insert into" time
server db : sybase 12.5 ASE (on both fastlinux & windows)

create table and insert commands - inside the code
(26 cols, 26 rows, char(20) all columns, prepare statement and excute ,
autocommit on)

freetds trace = yes
freetds trace level = 10

test app compiled on linux : redhat 6.2, g++ 2.95.3 , libc 2.1.3, stlport 4.53

linux sybase server : redhat 7.3 , P-4 2.4 Ghz , 1.5 Gb ram, 3COM 10/100 PCI
ethernet card
(to be called: fastlinux)

windows software : windows 2000 sp3 , ms visual c++ 6 sp3
Hardware (linux & windows) : P-III 800 Mhz , 256-384 Mb ram ,3COM 10/100 PCI
ethernet card


so here's my partial results:

client server network method
time(sec.) LPS
-------- -------- ------- --------------------
---------- -----
linux windows yes odbc++ over freetds 5.275
4.92
linux fastlinux yes odbc++ over freetds 1.587 16.38
fastlinux fastlinux local odbc++ over freetds 1.570
16.56
windows windows local odbc++ over ASE odbc 0.14 185
windows fastlinux yes odbc++ over ASE odbc 0.753
34


once i can use the DataDirect/Merant/DirectConnent TDS driver (all these name
are the same) , i will supply these
results too


Gad


begin 666 scroll.cpp
M"B-I;F-L=61E(#QO9&)C*RLO9')I=F5R;6%N86=E<BYH/@HC:6YC;'5D92 \
M;V1B8RLK+V-O;FYE8W1I;VXN:#X*(VEN8VQU9&4@/&]D8F,K*R]D871A8F%S
M96UE=&%D871A+F@^"B-I;F-L=61E(#QO9&)C*RLO<F5S=6QT<V5T+F@^"B-I
M;F-L=61E(#QO9&)C*RLO<F5S=6QT<V5T;65T861A=&$N:#X*(VEN8VQU9&4@
M/&]D8F,K*R]P<F5P87)E9'-T871E;65N="YH/@H*(VEN8VQU9&4@/&EO<W1R
M96%M/@H*(VEN8VQU9&4@/'-Y<R]T:6UE8BYH/@HC:6YC;'5D92 \=&EM92YH
M/@H*=7-I;F<@;F%M97-P86-E(&]D8F,["G5S:6YG(&YA;65S<&%C92!S=&0[
M"@H*9&]U8FQE(&-U<G1I;64H*0I["@ES=')U8W0@=&EM96(@=&EM96(Q.PH)
M=6YS:6=N960@;&]N9R!T+'1M.PH)9&]U8FQE(')E=%]T:6UE.PH*"69T:6UE
M*" F=&EM96(Q*3L*"@ET(#T@=&EM96(Q+G1I;64@.PH)=&T@/2!T:6UE8C$N
M;6EL;&ET;2 ["@ER971?=&EM93TH9&]U8FQE*70@*R H9&]U8FQE*71M+S$P
M,# N,#L*"0H)<F5T=7)N(')E=%]T:6UE.PH)"GT*"@HC:68@(61E9FEN960H
M3T1"0UA87U%4*0HC(&EN8VQU9&4@/'-T<G-T<F5A;3X*(V5L<V4*"B,@=6YD
M968@05-315)4"@IO<W1R96%M)B!O<&5R871O<CP\*&]S=')E86TF(&\L(&-O
M;G-T(%%3=')I;F<F(',I"GL*("!O(#P\($]$0D-86%]35%))3D=?0U-44BAS
M*3L*("!R971U<FX@;SL*?0HC96YD:68*"G-T871I8R!I;G0@87-S97)T:6]N
M<T9A:6QE9#TP.PH*(V1E9FEN92!!4U-%4E0H>"D)"0D)"0E<"F1O('L)"0D)
M"0D)"5P*("!I9B@A*'@I*2!["0D)"0D)"5P*(" @(&-E<G(@/#P@(D%S<V5R
M=&EO;B!<(B(@/#P@(W@@/#P@(EPB(&9A:6QE9"(@/#P@96YD;#L)7 H@(" @
M87-S97)T:6]N<T9A:6QE9"LK.R @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @7 H@('T)"0D)"0D)"5P*?2!W:&EL92AF86QS92D*
M"B-D969I;F4@3D%-15]04D5&25@@(F=A9"(*"B-D969I;F4@5$%"3$5?3D%-
M12!.04U%7U!2149)6" B=&5S="(*"B-D969I;F4@5$%"3$5?4D]74R R-@H*
M(V1E9FEN92!#3TQ3(#(V"@H*<W1A=&EC('9O:60@8W)E871E4W1U9F8H0V]N
M;F5C=&EO;BH@8V]N*0I["B @+R\@8W)E871E(&]U<B!T86)L90H@(%-T871E
M;65N="H@<W1M=#UC;VXM/F-R96%T95-T871E;65N="@I.PH@('-T;70M/F5X
M96-U=&55<&1A=&4@*")C<F5A=&4@=&%B;&4@(B!404),15].04U%("(H(B B
M9C$@0TA!4B@R,"D@3E5,3" L("(@(F8R($-(05(H,C I($Y53$P@+" B(")F
M,R!#2$%2*#(P*2!.54Q,("P@(B B9C0@0TA!4B@R,"D@3E5,3" L("(@(F8U
M($-(05(H,C I($Y53$PL("(@(F8V($-(05(H,C I($Y53$P@+" B(")F-R!#
M2$%2*#(P*2!.54Q,("P@(B B9C@@0TA!4B@R,"D@3E5,3" L("(@(F8Y($-(
M05(H,C I($Y53$P@+" B(")F,3 @0TA!4B@R,"D@3E5,3" L("(@(F8Q,2!#
M2$%2*#(P*2!.54Q,("P@(B B9C$R($-(05(H,C I($Y53$P@+" B(")F,3,@
M0TA!4B@R,"D@3E5,3" L("(@(F8Q-"!#2$%2*#(P*2!.54Q,(" L("(@(F8Q
M-2!#2$%2*#(P*2!.54Q,("P@(B B9C$V($-(05(H,C I($Y53$P@+" B(")F
M,3<@0TA!4B@R,"D@3E5,3" L("(@(F8Q."!#2$%2*#(P*2!.54Q,("P@(B B
M9C$Y($-(05(H,C I($Y53$P@+" B(")F,C @0TA!4B@R,"D@3E5,3" L("(@
M(F8R,2!#2$%2*#(P*2!.54Q,("P@(B B9C(R($-(05(H,C I($Y53$P@+" B
M(")F,C,@0TA!4B@R,"D@3E5,3" L("(@(F8R-"!#2$%2*#(P*2!.54Q,("P@
M(B B9C(U($-(05(H,C I($Y53$P@+" B(")F,C8@0TA!4B@R,"D@3E5,3" I
M(BD["B @"B @8V]U=" \/" B5&%B;&4@(B \/"!404),15].04U%(#P\("(@
M8W)E871E9"XB(#P\(&5N9&P["B @"B @9&5L971E('-T;70["GT*"B\O($1R
M;W!S('1H92!D871A8F%S92!O8FIE8W1S+@H*<W1A=&EC('9O:60@9')O<%-T
M=69F*$-O;FYE8W1I;VXJ(&-O;BD*>PH@(%-T871E;65N="H@<W1M=#UC;VXM
M/F-R96%T95-T871E;65N="@I.PH@('1R>2!["B @("!S=&UT+3YE>&5C=71E
M57!D871E*")D<F]P('1A8FQE("(@5$%"3$5?3D%-12D["B @("!C;W5T(#P\
M(")$<F]P<&5D('1A8FQE("(@/#P@5$%"3$5?3D%-12 \/"!E;F1L.PH@('T@
M8V%T8V@H4U%,17AC97!T:6]N)B!E*2!["B @?0H@( H@(&1E;&5T92!S=&UT
M.PI]"@IS=&%T:6,@3T1"0UA87U-44DE.1R!M86ME3F%M92AI;G0@;BD*>PHC
M:68@(61E9FEN960H3T1"0UA87U%4*0H@('-T<G-T<F5A;2!S<SL*("!S<R \
M/" B5&AI<R!I<R!R;W<@;G5M8F5R("(@/#P@;CL*("!R971U<FX@<W1R:6YG
M*'-S+G-T<B@I+'-S+G!C;W5N="@I*3L*(V5L<V4*("!14W1R:6YG(',H(E1H
M:7,@:7,@<F]W(&YU;6)E<B B*3L*("!S*SU14W1R:6YG.CIN=6UB97(H;BD[
M"B @<F5T=7)N(',["B-E;F1I9@I]"@H*<W1A=&EC('9O:60@<&]P=6QA=&4H
M0V]N;F5C=&EO;BH@8V]N*0I["B @>PH@(" @4')E<&%R9613=&%T96UE;G0J
M('!S=&UT/6-O;BT^<')E<&%R95-T871E;65N= H@(" @(" H(FEN<V5R="!I
M;G1O("(@5$%"3$5?3D%-12 B*&8Q+&8R+&8S+&8T+&8U+&8V+&8W+&8X+&8Y
M+&8Q,"QF,3$L9C$R+&8Q,RQF,30L9C$U+&8Q-BQF,3<L9C$X+&8Q.2QF,C L
M9C(Q+&8R,BQF,C,L9C(T+&8R-2QF,C8I('9A;'5E<R H/RP_+#\L/RP_+#\L
M/RP_+#\L/RP_+#\L/RP_+#\L/RP_+#\L/RP_+#\L/RP_+#\L/RP_*2(I.PH@
M(" @9F]R*&EN="!I/3 [(&D\5$%"3$5?4D]74SL@:2LK*0H@(" @>PH@(" @
M("!F;W(@*&EN="!C/3$[8SP]0T],4R [(&,K*RD*(" @(" @"0EP<W1M="T^
M<V5T4W1R:6YG*&,L;6%K94YA;64H:2DI.PH@(" @(" )"0H)("!P<W1M="T^
M97AE8W5T955P9&%T92 AT I.PH@(" @?0H@(" @"B @("!D96QE=&4@<'-T;70[
M"B @("!C;W5T(#P\("));G-E<G1E9" B(#P\(%1!0DQ%7U)/5U,@/#P@(B!R
M;W=S+B(@/#P@96YD;#L*("!]"GT*"@IS=&%T:6,@=F]I9"!C;VUP87)E*$-O
M;FYE8W1I;VXJ(&-O;BD*>PH@("\O(&1E8VED92!W:&5T:&5R('=E('-H;W5L
M9"!U<V4@82!S8W)O;&P@:6YS96YS:71I=F4@"B @+R\@;W(@82!S8W)O;&P@
M<V5N<VET:79E(&-U<G-O<@H@( H@(&EN="!R<W1Y<&4["B @:6YT(')S8V]N
M8SL*("!$871A8F%S94UE=&%$871A*B!M9#UC;VXM/F=E=$UE=&%$871A*"D[
M"@H@(&EF*&UD+3YS=7!P;W)T<U)E<W5L=%-E=%1Y<&4H4F5S=6QT4V5T.CI4
M65!%7U-#4D],3%])3E-%3E-)5$E612DI('L*(" @(')S='EP93U297-U;'13
M970Z.E194$5?4T-23TQ,7TE.4T5.4TE4259%.PH@('T@96QS92!I9BAM9"T^
M<W5P<&]R='-297-U;'139714>7!E*%)E<W5L=%-E=#HZ5%E015]30U)/3$Q?
M4T5.4TE4259%*2D@>PH@(" @<G-T>7!E/5)E<W5L=%-E=#HZ5%E015]30U)/
M3$Q?4T5.4TE4259%.PH@('T@96QS92!["B @("!C;W5T(#P\(")3:VEP<&EN
M9R!C;VUP87)E+"!D871A('-O=7)C92!D;V5S(&YO="!S=7!P;W)T('-C<F]L
M;&%B;&4@8W5R<V]R<R(@"@D@/#P@96YD;#L*(" @(')E='5R;CL*("!]"@H*
M("!I9BAM9"T^<W5P<&]R='-297-U;'13971#;VYC=7)R96YC>2AR<W1Y<&4L
M4F5S=6QT4V5T.CI#3TY#55)?4D5!1%]/3DQ9*2D@>PH@(" @+R\@=&AI<R!I
M<R!A;&P@=V4@;F5E9 H@(" @<G-C;VYC/5)E<W5L=%-E=#HZ0T].0U527U)%
M041?3TY,63L*("!](&5L<V4@>PH@(" @<G-C;VYC/5)E<W5L=%-E=#HZ0T].
M0U527U501$%404),13L*("!]"B @"B @4W1A=&5M96YT*B!S=&UT/6-O;BT^
M8W)E871E4W1A=&5M96YT"B @(" H<G-T>7!E+')S8V]N8RD["B @4F5S=6QT
M4V5T*B!R<SUS=&UT+3YE>&5C=71E475E<GD*(" @("@B<V5L96-T(&ED+&YA
M;64@9G)O;2 B(%1!0DQ%7TY!344I.PH*("!!4U-%4E0H<G,M/FES0F5F;W)E
M1FER<W0H*2D["B @05-315)4*')S+3YF:7)S="@I*3L*("!!4U-%4E0H(7)S
M+3YI<T)E9F]R949I<G-T*"DI.PH@($%34T525"AR<RT^:7-&:7)S="@I*3L*
M(" *("!!4U-%4E0H<G,M/FQA<W0H*2D["B @05-315)4*')S+3YI<TQA<W0H
M*2D["B @05-315)4*"%R<RT^:7-!9G1E<DQA<W0H*2D["B @<G,M/F%F=&5R
M3&%S="@I.PH@($%34T525"AR<RT^:7-!9G1E<DQA<W0H*2D["@H@($%34T52
M5"AR<RT^<')E=FEO=7,H*2D["B @05-315)4*')S+3YI<TQA<W0H*2D["B @
M"B @"B @8V]U=" \/" B4&]S:71I;VYE9"!O;B!T:&4@;&%S="!R;W<@*"(@
M"B @(" @(" \/"!R<RT^9V5T4F]W*"D@/#P@(BDB(#P\(&5N9&P["B @:6YT
M(&D]5$%"3$5?4D]74SL*(" *("!D;R!["B @("!I+2T["B @("!/1$)#6%A?
M4U1224Y'(&YA;64H;6%K94YA;64H:2DI.PH@(" @05-315)4*')S+3YG971)
M;G0H,2D@/3T@:2D["B @("!!4U-%4E0H<G,M/F=E=%-T<FEN9R@R*3T];F%M
M92D["B @?2!W:&EL92AR<RT^<')E=FEO=7,H*2D["B @05-315)4*&D]/3 I
M.PH@($%34T525"AR<RT^:7-"969O<F5&:7)S="@I*3L*("!C;W5T(#P\(%1!
M0DQ%7U)/5U,@/#P@(B!R;W=S(&-H96-K960@=VET:"!E>'!E8W1E9"!V86QU
M97,N(B \/"!E;F1L.PH*("!D96QE=&4@<W1M=#L@+R]W:6QL(&MI;&P@<G,*
M(" @( I]"@H*"@H*:6YT(&UA:6XH:6YT(&%R9V,L(&-H87(J*B!A<F=V*0I[
M"B @"B @9&]U8FQE('1I;64Q+"!T:6UE,CL*(" *("!I9BAA<F=C(3TR("8F
M(&%R9V,A/30I('L*(" @(&-E<G(@/#P@(E5S86=E.B B(#P\(&%R9W9;,%T@
M/#P@(B!C;VYN96-T+7-T<FEN9R(@/#P@96YD; H)(" @(" @(#P\(")O<B @
M(" @(B \/"!A<F=V6S!=(#P\("(@9'-N('5S97)N86UE('!A<W-W;W)D(B \
M/"!E;F1L.PH@(" @<F5T=7)N(# ["B @?0H@('1R>2!["B @("!#;VYN96-T
M:6]N*B!C;VX["B @("!I9BAA<F=C/3TR*2!["B @(" @(&-O=70@/#P@(D-O
M;FYE8W1I;F<@=&\@(B \/"!A<F=V6S%=(#P\("(N+BXB(#P\(&9L=7-H.PH@
M(" @("!C;VX]1')I=F5R36%N86=E<CHZ9V5T0V]N;F5C=&EO;BAA<F=V6S%=
M*3L*(" @('T@96QS92!["B @(" @(&-O=70@/#P@(D-O;FYE8W1I;F<@=&\@
M9'-N/2(@/#P@87)G=ELQ70H)(" @/#P@(BP@=6ED/2(@/#P@87)G=ELR72 *
M"2 @(#P\("(L('!W9#TB(#P\(&%R9W9;,UT@/#P@(BXN+B(@/#P@9FQU<V@[
M"B @(" @(&-O;CU$<FEV97)-86YA9V5R.CIG971#;VYN96-T:6]N*&%R9W9;
M,5TL87)G=ELR72QA<F=V6S-=*3L*(" @('T*(" @(&-O=70@/#P@(B!D;VYE
M+B(@/#P@96YD;#L*"B @(" O+R!U<V4@875T;V-O;6UI= H@(" @:68H8V]N
M+3YG971-971A1&%T82@I+3YS=7!P;W)T<U1R86YS86-T:6]N<R@I*2!["B @
M(" @(&-O;BT^<V5T075T;T-O;6UI="AT<G5E*3L*(" @('T*+R\@(" @("!C
M;VXM/G-E=%1R86-E1FEL92@B+W1M<"]F:7-K(BD["B\O(" @(" @8V]N+3YS
M9714<F%C92AT<G5E*3L*"B @("!D<F]P4W1U9F8H8V]N*3L*(" @(&-R96%T
M95-T=69F*&-O;BD["B @(" *(" )=&EM93$]8W5R=&EM92 AT I.PH@(" @<&]P
M=6QA=&4H8V]N*3L*(" @('1I;64R/6-U<G1I;64H*3L*(" *(" )8V]U=" \
M/" B<&]U<&QA=&EO;B!T:6UE("AR;W=S/2(\/%1!0DQ%7U)/5U,\/"(L8V]L
M<STB/#Q#3TQ3/#PB*2 ]("(\/'1I;64R+71I;64Q/#PB('-E8V]N9',N7&XB
M.PH@( H@( ED96QE=&4@8V]N.PH*(" @(&EF*&%S<V5R=&EO;G-&86EL960^
M,"D@>PH@(" @("!C;W5T(#P\(&%S<V5R=&EO;G-&86EL960@/#P@(B!A<W-E
M<G1I;VYS(&9A:6QE9"XB(#P\(&5N9&P["B @("!]"B @?2!C871C:"A344Q%
M>&-E<'1I;VXF(&4I('L*(" @(&-E<G(@/#P@96YD;" \/"!E+F=E=$UE<W-A
M9V4H*2 \/"!E;F1L.PH@(" @<F5T=7)N(#$["B @?0H*("!R971U<FX@,#L*
"?0H`
`
end






Archive powered by MHonArc 2.6.24.

Top of Page