RE: Client Access ODBC Optimization

[Chris Bipes <rpg@xxxxxxxxxxxxxxx>]

We use client access data queues to send a request to a server program on
the AS400.  This gives us sub second response time.  The server has the
files open all the time and sits at DEQW.  It burns very little cpu while
waiting.  We also use .ASP and VB to get to the client access data queue
APIs.  Contact Ken Slaugh at Chouinard & Mhyre for detail and sample source
for the VB interfaces.  The server program on the AS400 is a data queue
server which we also use for terminal access, ect.



Christopher K. Bipes     mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst   mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.         http://www.cross-check.com
6119 State Farm Drive    Phone: 707 586-0551 x 1102
Rohnert Park CA  94928 Fax: 707 586-1884

*Note to Recruiters
Neither I, nor anyone that I know of, is interested in any new and/or
exciting positions. Please do not contact me.

>  -----Original Message-----
> From:         Cyndi Bradberry [mailto:CyndiB@IHFA.ORG] 
> Sent: Tuesday, January 25, 2000 1: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
+---