Re: Problem with reading in packet mode

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Kevin,

Thank you for your quick reply.

I did try using the new functions: SQLSetStmtAttr instead of
SQLSetStmtOption and SQLFetchScroll instead of SQLExtendedFetch
respectively,
and still the problem is absolutely the same.

I attached a revised sample.

Thanks,
Ovidiu

"Kevin Yu [MSFT]" <v-kevy@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:byomeErhFHA.940@xxxxxxxxxxxxxxxxxxxxxxxx
> Hi Ovidiu,
>
> First of all, I would like to confirm my understanding of your issue. From
> your description, I understand that when you call SQLSetStmtOption()
> before
> SQLExecDirect() the performance is quite poor. If there is any
> misunderstanding, please feel free to let me know.
>
> Yes, as you know, the SQLSetStmtOption can be called before/after
> SQLExecDirect. However, from ODBC 3.x SQLSetStmtOption is deprecated. It
> has been replaced by SQLSetStmtAttr. So I suggest you try to use
> SQLSetStmtAttr to see if performance goes better. Please check the
> following link for more information.
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/od
> bcsqlsetstmtoption.asp
>
> If that still doens't work, please feel free to reply to the post.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>


begin 666 TestReadPacketNew.cpp
M+R]T97-T(')E860@<&%C:V5T#0H-"B-I;F-L=61E(#QW:6YD;W=S+F@^#0HC
M:6YC;'5D92 \<W%L+F@^#0HC:6YC;'5D92 \<W%L97AT+F@^#0HC:6YC;'5D
M92 \:6]S=')E86TN:#X-"B-I;F-L=61E(#QS=')I;F<N:#X-"B-I;F-L=61E
M(#QM871H+F@^#0HC:6YC;'5D92 \=&EM92YH/@T*#0IC;&%S<R!/1$)#7T-L
M87-S#0I[#0H@(" @<'5B;&EC.@T*(" @(" @("!(14Y6(" @("!%;G9(86YD
M;&4[#0H@(" @(" @($A$0D,@(" @($-O;DAA;F1L93L-"B @(" @(" @2%-4
M350@(" @4W1M=$AA;F1L93L@#0H@(" @(" @(%)%5$-/1$4@(')C.PT*#0H@
M(" @<'5B;&EC.@T*(" @(" @("!/1$)#7T-L87-S*"D[#0H@(" @(" @('Y/
M1$)#7T-L87-S*"D[#0H@(" @(" @(%)%5$-/1$4@(%-H;W=297-U;'1S*"D[
M(" -"@D)=F]I9"!0<FEN=$5R<F]R*"D[#0I].PT*#0I/1$)#7T-L87-S.CI/
M1$)#7T-L87-S*"D-"GL-"B @("!R8R ](%-13%]354-#15-3.PT*#0H@(" @
M<F,@/2!344Q!;&QO8T5N=B@F16YV2&%N9&QE*3L-"@T*(" @(&EF("AR8R ]
M/2!344Q?4U5#0T534RD-"B @(" @(" @<F,@/2!344Q!;&QO8T-O;FYE8W0H
M16YV2&%N9&QE+" F0V]N2&%N9&QE*3L-"GT-"@T*3T1"0U]#;&%S<SHZ?D]$
M0D-?0VQA<W,H*0T*>PT*(" @(&EF("A#;VY(86YD;&4@(3T@3E5,3"D-"B @
M(" @(" @4U%,1G)E94-O;FYE8W0H0V]N2&%N9&QE*3L-"@T*(" @(&EF("A%
M;G9(86YD;&4@(3T@3E5,3"D-"B @(" @(" @4U%,1G)E945N=BA%;G9(86YD
M;&4I.PT*?0T*#0I2151#3T1%($]$0D-?0VQA<W,Z.E-H;W=297-U;'1S*'9O
M:60I#0I[#0H)4D540T]$10D@<F,@/2 P.PD-"B @("!344Q)3E1%1T52(" @
M1FQD07)R87E;,3!=.PT*"5-13$E.5$5'15(@("!);F1!<G)A>5LQ,%T[#0H-
M"B @("!344Q54TU!3$Q)3E0@4F]W4W1A='5S07)R87E;,3!=.PT*(" @(%-1
M3%5)3E1%1T52("!.=6U2;W=S1F5T8VAE9#L-"B @(" -"@DO+W)C(#T@4U%,
M4V5T4W1M=$%T='(H4W1M=$AA;F1L92P@4U%,7T%45%)?4D]77T))3D1?5%E0
M12P@4U%,7T))3D1?0EE?0T],54U.+" P*3L-"B @(" O+W)C(#T@4U%,4V5T
M4W1M=$%T='(H4W1M=$AA;F1L92P@4U%,7T%45%)?4D]77U-405154U]05%(L
M(%)O=U-T871U<T%R<F%Y+" P*3L-"B @(" O+W)C(#T@4U%,4V5T4W1M=$%T
M='(H4W1M=$AA;F1L92P@4U%,7T%45%)?4D]74U]&151#2$5$7U!44BP@)DYU
M;5)O=W-&971C:&5D+" P*3L-"@T*"7)C(#T@4U%,0FEN9$-O;"A3=&UT2&%N
M9&QE+" Q+"!344Q?0U],3TY'+"!&;&1!<G)A>2P@,"P@26YD07)R87DI.PT*
M#0H):6YT(&-N=" ](# [#0H)=VAI;&4H,2D-"@E[#0H)"2\O<F,@/2!344Q%
M>'1E;F1E9$9E=&-H*%-T;71(86YD;&4L(%-13%]&151#2%].15A4+" P+" F
M;E)O=T9E=&-H960L('!2;W=3=&%T=7,I.PT*"0ER8R ](%-13$9E=&-H4V-R
M;VQL*%-T;71(86YD;&4L(%-13%]&151#2%].15A4+" P*3L-"@T*"0EI9B H
M4U%,7TY/7T1!5$%?1D]53D0@/3T@<F,I"0T*"0D)8G)E86L[#0H-"@D)8VYT
M*RL[#0H)"0T*"0DO+VEF("@H8VYT("4@-3 P,# I(#T](# I#0H)"2\O"6-O
M=70@/#P@8VYT(#P\(&5N9&P[#0H)?0T*#0H@(" @<F5T=7)N*')C*3L-"GT-
M"@T*=F]I9"!/1$)#7T-L87-S.CI0<FEN=$5R<F]R*"D-"GL-"@E344Q21515
M4DX@(')C.PT*"5-13$-(05()"0ES=')3=&%T95M344Q?4U%,4U1!5$5?4TE:
M12 K(#%=.PT*"5-13$E.5$5'15()"7-Q;$1B0V]D92 )"3T@,#L-"@E344Q#
M2$%2"0D)<W1R1&)-97-S86=E6U-13%]-05A?34534T%'15],14Y'5$A=.PT*
M"5-13%--04Q,24Y4"0EC8F5R<F]R;7-G"0D](# [#0H)8VAA<@D)"7-T<ELQ
M,#!=.PT*"7-T<F-P>2AS='(L("(B*3L-"@D-"@ED;PT*"7L-"@D)<F,@/2!3
M44Q%<G)O<BA%;G9(86YD;&4L($-O;DAA;F1L92P@,"P@<W1R4W1A=&4L("9S
M<6Q$8D-O9&4L('-T<D1B365S<V%G92P@4U%,7TU!6%]-15-304=%7TQ%3D=4
M2" M(#$@+" F8V)E<G)O<FUS9R I.PT*"0D-"@D):68@*"!R8R ]/2!344Q?
M4U5#0T534R I#0H)"7L-"@D)"7-T<F-A="AS='(L("AC;VYS="!C:&%R*BD@
M<W1R4W1A=&4I.PT*"0D)<W1R8V%T*'-T<BP@(B @(BD[#0H)"0ES=')C870H
M<W1R+" H8V]N<W0@8VAA<BHI('-T<D1B365S<V%G92D[#0H)"7T-"@E]('=H
M:6QE*"!R8R ]/2!344Q?4U5#0T534R I.PT*"0T*"6-O=70@/#P@(D5R<F]R
M(&UE<W-A9V4Z("(@/#P@96YD;#L-"@EC;W5T(#P\('-T<B \/"!E;F1L.PT*
M?0T*#0IV;VED(&UA:6XH*0T*>PT*"71I;65?="!S=&%R=#L-"@ET:6UE7W0@
M96YD.PT*#0H)=&EM92@F<W1A<G0I.PT*#0H@(" @4D540T]$12 @<F,@/2!3
M44Q?4U5#0T534SL-"B @("!344Q#2$%2("!$0DYA;65;,C!=(#T@(E-13#(P
M,# B.PT*(" @(%-13$-(05(@(%-13%-T;71;,C4U73L-"@E344Q524Y414=%
M4B @07)R87E3:7IE(#T@,3 [#0H-"B @("!/1$)#7T-L87-S("!%>&%M<&QE
M.PT*#0H@(" @:68@*$5X86UP;&4N0V]N2&%N9&QE("$]($Y53$PI#0H@(" @
M>PT*(" @(" @("!R8R ](%-13$-O;FYE8W0H17AA;7!L92Y#;VY(86YD;&4L
M($1"3F%M92P@4U%,7TY44RP@#0H@(" @(" @(" @(" @(" @("A344Q#2$%2
M("HI(")R;F1D8C4B+"!344Q?3E13+" H4U%,0TA!4B J*2 B;W9I9&EU(BP@
M4U%,7TY44RD[#0H-"B @(" @(" @<F,@/2!344Q!;&QO8U-T;70H17AA;7!L
M92Y#;VY(86YD;&4L("9%>&%M<&QE+E-T;71(86YD;&4I.PT*#0H@(" @(" @
M(&EF("AR8R ]/2!344Q?4U5#0T534R!\?"!R8R ]/2!344Q?4U5#0T534U]7
M251(7TE.1D\I#0H@(" @(" @('L-"B @(" @(" @(" @('-T<F-P>2@H8VAA
M<B J*2!344Q3=&UT+" B4T5,14-4($9I96QD,2!&4D]-(%1214%$(BD[#0H-
M"@D)"7)C(#T@4U%,4V5T4W1M=$%T='(H17AA;7!L92Y3=&UT2&%N9&QE+"!3
M44Q?05144E]23U=?05)205E?4TE:12P@*%-13%!/24Y415(I($%R<F%Y4VEZ
M92P@,"D[#0H-"@D)"2\O<F,@/2 Z.E-13%-E=%-T;71/<'1I;VXH17AA;7!L
M92Y3=&UT2&%N9&QE+"!344Q?4D]74T547U-)6D4L(#$P*3L)#0H)"0ER8R ]
M(%-13$5X96-$:7)E8W0H17AA;7!L92Y3=&UT2&%N9&QE+"!344Q3=&UT+"!3
M44Q?3E13*3L-"@D)"2\O<F,@/2 Z.E-13%-E=%-T;71/<'1I;VXH17AA;7!L
M92Y3=&UT2&%N9&QE+"!344Q?4D]74T547U-)6D4L(#$P*3L)#0H-"@D)"2\O
M<F,@/2!344Q39713=&UT071T<BA%>&%M<&QE+E-T;71(86YD;&4L(%-13%]!
M5%127U)/5U]!4E)!65]325I%+" H4U%,4$])3E1%4BD@07)R87E3:7IE+" P
M*3L-"@T*(" @(" @(" @(" @:68@*')C(#T](%-13%]354-#15-3*0T*(" @
M(" @(" @(" @(" @($5X86UP;&4N4VAO=U)E<W5L=',H*3L-"@T*(" @(" @
M(" @(" @:68@*$5X86UP;&4N4W1M=$AA;F1L92 A/2!.54Q,*0T*(" @(" @
M(" @(" @(" @(')C(#T@4U%,1G)E95-T;70H17AA;7!L92Y3=&UT2&%N9&QE
M+"!344Q?1%)/4"D[#0H@(" @(" @('T-"@D)96QS90T*"0E[#0H)"0E%>&%M
M<&QE+E!R:6YT17)R;W(H*3L-"@D)?0T*#0H@(" @(" @(')C(#T@4U%,1&ES
M8V]N;F5C="A%>&%M<&QE+D-O;DAA;F1L92D[#0H@(" @?0T*#0H)=&EM92@F
M96YD*3L-"@T*"6-O=70@/#P@(G1I;64@96QA<'-E9" ]("(@/#P@96YD("T@
C<W1A<G0@/#P@(B!S96-O;F1S(B \/"!E;F1L.PT*?0T*#0H`
`
end

.