FreeTDS Development Group

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

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