|
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 mailing list archive is Copyright 1997-2024 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.