RE: CA ODBC serving 400 data to web

[Cyndi Bradberry <CyndiB@xxxxxxxx>]

Mark,

I understand your problem. We are also serving off IIS and retrieving data
from our AS/400 (Model 510). On one web site that is in production, the
initial log-on can take anywhere from 30 to 90 seconds. However at the time,
we didn't know any other way of going. If you want to remain with ODBC,
there is some system tuning that I have heard can be done if you have a
server model 400. We tried many different settings on the NT box, but
nothing seemed to work. At times, we could have an ODBC request taking 76%
of our processor. Other than that, make sure that you refer to the variables
by their PC name, not by the record set name. As soon as you retrieve a
record, move the data into local variables and manipulate them.  

Since then, we have learned about sockets. 3 of four sites have been
changed, with the really ugly one probably going live tomorrow. I would
definitely recommend that you take a look at the socket programming section
of the Sorcerer's Guide at
http://www.redbooks.ibm.com/abstracts/sg245402.html

If you need help with the VB .dll that needs to be running on the IIS box,
contact me privately and I will put you in touch with the person who wrote
ours.

Good Luck,
Cyndi Bradberry
Boise, ID


-----Original Message-----
From: Mark Allen [mailto:markallen@kellyskids.com]
Sent: Thursday, September 07, 2000 1:59 PM
To: MIDRANGE-L
Subject: CA ODBC serving 400 data to web


First thing, thanks to everyone who helped me previously in getting this set
up.  Turned out the problem was in MS and we needed to download/install a
new MDAC file.

Now that I have a web page (served from IIS on NT 4 machine) that pulls data
from our AS/400 it seems to be "extremely" slow.  The test I am running is
to bring in every record (13 in the test file) and display 5 fields.  It
takes approx 16-20 seconds for the page to display!!!!

What can I do/where can I look to increase this performance.  Final app may
bring in a couple hundred records of 7-8 fields each.



Mark Allen
IS Manager
Kelly's Kids
markallen@kellyskids.com

+---
| 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
+---
+---
| 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
+---