RE: Client Access ODBC Optimization

[Nathan Andelin <nandelin@xxxxxxxxxxxxxxx>]

Cyndi,

Sounds like you may be connecting to the database and submitting SQL
directly from the VB Script.  That can be resesource intensive and slow -
especially when connecting to another computer.  A different technique is to
create a Windows COM object that maintains a constant connection to the
AS/400 and caches the necessary files.  You might run the COM object under
Microsoft Transaction Server, if you want.  You might use code like ...
myServer = createObject('myCOMServer') and
myServer.giveMeWhatINeedInHTMLPlease(UserInput).

Nathan.


>  -----Original Message-----
> From:         Cyndi Bradberry [mailto:CyndiB@IHFA.ORG] 
> Sent: Tuesday, January 25, 2000 2:11 PM
> To:   Midrange-L (E-mail)
> 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
> 
> 
+---
| 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
+---