Re: Client Access ODBC Optimization -- MIDRANGE-L

A good set of tips relative to ODBC performance is on the following web
site:

http://www.as400.ibm.com/developer/client/index.html

You'll get the biggest benefit from building a library of stored procedures
on the AS/400 that can be accessed through ODBC;  this can substantially
reduce the amount of traffic going back and forth between the PC and the
AS/400 by switching you to a transactional paradigm.

Janet Krueger
Rochester Technology Center, part of D H Andrews Group
www.dhagroup.com/rtc/





Cyndi Bradberry <CyndiB@IHFA.ORG> on 01/25/2000 03:11:28 PM

Please respond to MIDRANGE-L@midrange.com

To:   "Midrange-L (E-mail)" <Midrange-L@midrange.com>
cc:    (bcc: Janet Krueger/dhagroup/US)
Subject:  Client Access ODBC Optimization




Everyone,

For reasons beyond my control, we are web-serving from an NT box using
Microsoft IIS. Our web applications (.asp using VBScript) use Client Access
ODBC to reach back to the AS/400 where all our data resides.  We have one
application in particular that accesses 17 different files. Eight files are
update; the other nine are validation table files which are used for
pull-down menus on our web application. We tried a time test by replicating
the table files on our SQL server and checking how long it took to load
from
each source. SQL server won by several seconds in each test.  Multiplying
that out by 9 files.....it makes a big difference to people coming in over
the internet on a slow connection.  Anyway, corporate policy says that data
resides on the AS/400, we just get to it in different ways. So we have to
come up with methods to make the record retrieval faster.

My Questions:
Is there a way to make the ODBC connection faster ?

Is there some other ODBC client that we should try ?

TIA,
Cyndi Bradberry
IHFA
Boise, ID




(UUEncoded file named: att1.unk follows)
(Its format is: File type unknown )

begin 644 att1.unk
M>)\^(B$5`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<`
M&````$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`06``P`.````T`<!`!D`
M#@`+`!P``@`H`0$@@`,`#@```-`'`0`9``X`"P`@``(`+`$!"8`!`"$```!%
M.3<Q-#DU,S1!1#-$,S$Q0C5",#`P,3`T0C<Q131!00`#!P$$@`$`(````$-L
M:65N="!!8V-E<W,@3T1"0R!/<'1I;6EZ871I;VX`,`L!#8`$``(````"``(`
M`0.0!@`<"0``,@````(!<0`!````%@````&_9WB%<L_(ICC311'3KKX`8)?7
M2[P```,`WC^O;P```P`(@`@@!@``````P````````$8`````4H4``/`3```>
M``F`""`&``````#`````````1@````!4A0```0````0````X+C4`"P`*@`@@
M!@``````P````````$8`````!H4````````#``N`""`&``````#`````````
M1@`````!A0````````L``(`((`8``````,````````!&``````.%````````
M"P`4@`@@!@``````P````````$8`````#H4````````#``*`""`&``````#`
M````````1@`````0A0````````,`%8`((`8``````,````````!&`````!&%
M`````````P`7@`@@!@``````P````````$8`````&(4````````>`":`""`&
M``````#`````````1@`````VA0```0````$`````````'@`G@`@@!@``````
MP````````$8`````-X4```$````!`````````!X`*(`((`8``````,``````
M``!&`````#B%```!`````0`````````+`#.`"R`&``````#`````````1@``
M````B`````````L`-8`+(`8``````,````````!&``````6(`````````@$)
M$`$```"8`P``E`,``!`%``!,6D9UHI(U3@,`"@!R8W!G,3(U%C(`^`M@;@X0
M,#,SZ0%5,S8!Z"`"I`/C`@`$8V@*P'-E=#`@'P<3`H,`4`15$7E&:7A1"8!S
M>7,"@'T*@75&8P!0"P-U;&X"(&51`K$@178$D'D5H2PW"J(*A`J`1@6Q"7!A
M<Q,"(`0@8F46460@;1QY(`6@`C`#8&PL(#AW92`*P!E@&5!B+<D1T')V"X!G
M(`-2&7`)`Z!.5!@0;W@@=7L`D!I130W@`V`7T`&`(,!)25,N($\(<!FRC1EP
M<`M0#>!A=&D7XA0H+A?`<!ME5D)3[04#*1MA&6!#'7`)\`5`&$%C8P>0!"!/
M1$+P0R!T;Q>2$9`8$`#0$FL@TG1H&6!!4R_T-#`2`'<B`!F1!T`#(.D(82!D
M':!A%Y$`D`$`\G,<H"!7&6`1H!8@(S!K%;`=.B`+@"`*L1VP8W\5<`K!(?`=
MH!EP(#,'D3&V-R-P!I!F(L$?\68#$&$D(D5I9V@H91ES==)P(X%E.R'C;R'Q
M!<#W`P`E`AF1=@=`)``EE`&1_RB@*44BH`W@(5`ILQ'0&'`+`A`%P'`5<&PM
M9&_V=P.@!X!N&W`DX2,S'0W_'*`D<1CP")`8<".P';`'@/<@T`>0!4!B&*`)
M<!UE&E&'(?(L6B]%4U%,(!H"7RKA`'`8<!&0!9!K&D)H;2Z@(`D`&E%I!4`@
MX&_[(:,)`&$MX1J2(2,7T`AP]R!`'*`T>7<EP3(1$=`6(?\'0#2A&,$40"7B
M(2,QPB1![DT5<!VP"U!Y,L0F\0A@O3'S.2AU/:(V@0#`:RF"'Q@0*0`GUR!`
M(-)P96^W"U`98`6@;1I")?%O-.)_(?(+@"HP!*`1X"\R([!S;PD`!^`8P16P
M8S!D$A!NL'EW87D9,`6A<`6P_RHA)A`&\`W@.:%#H`0@)M-O(XHO,B'X&3-J
M&W`%0&=_0<$@X3:!)?$GZ$.1)#%3_R#P&5$DHR#A0#$ITAE`-H#_(5`'@"'P
M!'!%(2#P/B(AX_\)<`6A&'`)<##R*Z$:<!?`U4&!+A:J31B@40I0,>#U'<(Z
M%J1)12(BPTDR2\OG()-"F$V5(#\*XQ;F4`=_%]`QD2JT4;0?Q";3&5%S7S7P
M%7`8<!CP&*`_%JI4?$E!%ID+,`S0`<$?H'E1&&!I($(Z`&08('(C%D!/I4A&
M01:D0F_W!``6@!Q@1!:E`$%860$Q"Q:S%*$`7?`>`'```0```"````!#;&EE
M;G0@06-C97-S($]$0D,@3W!T:6UI>F%T:6]N``,`)@```````P`V```````+
M``(``0````,`_3_D!```0``Y`,`[PKYX9[\!`P#Q/PD$```>`#%``0````<`
M``!#64Y$24(```,`&D``````'@`P0`$````'````0UE.1$E"```#`!E`````
M``L`\A`!`````P"`$/____\"`4<``0```"H```!C/553.V$](#MP/4E(1D$[
M;#U-05)3+3`P,#$R-3(Q,3$R.%HM-S$W,P````(!^3\!````10````````#<
MIT#(P$(0&K2Y"``K+^&"`0`````````O3SU)2$9!+T]5/4E$04A/+T-./5)%
M0TE0245.5%,O0TX]0UE.1$E"`````!X`^#\!````$````$-Y;F1I($)R861B
M97)R>0`>`#A``0````<```!#64Y$24(```(!^S\!````10````````#<IT#(
MP$(0&K2Y"``K+^&"`0`````````O3SU)2$9!+T]5/4E$04A/+T-./5)%0TE0
M245.5%,O0TX]0UE.1$E"`````!X`^C\!````$````$-Y;F1I($)R861B97)R
M>0`>`#E``0````<```!#64Y$24(``$``!S"R%+N^>&>_`4``"#`NEP7!>&>_
M`1X`/0`!`````0`````````>`!T.`0```"````!#;&EE;G0@06-C97-S($]$
M0D,@3W!T:6UI>F%T:6]N`!X`-1`!````-P```#PU-$1".#-%0S8Q0S1$,S$Q
M0C5!1C`P,3`T0C<Q131!03`Q.3<Y-$!M87)S+FEH9F$N;W)G/@``"P`I````
M```+`",```````,`!A#&2",U`P`'$$4#```#`!`0``````,`$1``````'@`(
M$`$```!E````159%4EE/3D4L1D]24D5!4T].4T)%64].1$U90T].5%)/3"Q7
M14%215=%0BU315)624Y'1E)/34%.3E1"3UA54TE.1TU)0U)/4T]&5$E)4T]5
M4E=%0D%04$Q)0T%424].4RA!4P`````"`7\``0```#<````\-31$0C@S14,V
M,4,T1#,Q,4(U048P,#$P-$(W,44T04$P,3DW.31`;6%R<RYI:&9A+F]R9SX`
#`)H3
`
end


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---