Oops.  Didn't mean to imply it was the STRDBG command - forget the name, but
there is a performance monitoring tool that logs, in great detail, the
QZDASOINIT jobs.  This showed each statement, and how long it took to
complete it.

I'll add one more piece.  We currently use the AS/400 as the database server
for our web applications, but if we cannot get the system performing better
we'll have to migrate the apps off the 400.  Am hoping this is not the case
(last thing I need is another replication project) but the performance
difference is that significant.

JN

-----Original Message-----
From: Nathan M. Andelin [mailto:nandelin@relational-data.com]
Sent: Monday, December 31, 2001 3:54 PM
To: midrange-l@midrange.com
Subject: Re: - the simple query on the 400: SUBJECT CHANGE to SQL Server
faster


From: <Jim.Nelson@RCIS-NET.COM>
> Running debug on the AS/400 shows the database itself
> is competitive, but the ODBC layer seems to be much slower
> when compared to the SQL server connection.

How would running debug (STRDBG ?) give any indication of OS/400 database
performance in handling an ODBC request?

Thanks,

Nathan M. Andelin
www.relational-data.com


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.