Stored Procedure performance -- RPG400-L

Subject: Stored Procedure performance
From: sublime78ska@xxxxxxxxx
Date: Thu, 27 Feb 2003 13:54:44 +0000
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the AS400 / iSeries <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>,<mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>,<mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

I have a stored procedure (which is an RPG pgm) on AS400B which is called from
an SQLRPGLE pgm on AS400A.  These AS400's are in different parts of the country.
 The pgm on AS400A reads about 7 million records and calls the stored procedure
about 4 million times. 

Performance is abysmal.  I thought performance would be better than DDM'ing to
two files but it is actually worse.

Are there any ways to improve performance?  Or to determine where the
performance problem is?  Does the stored procedure job on AS400B end after each
call?

Thanks,

Phil

As an Amazon Associate we earn from qualifying purchases.

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