RE: - the simple query on the 400: SUBJECT CHANGE to SQL Server faster

[Jim.Nelson@xxxxxxxxxxxx]

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.