|
Brian, Are you sure that the bottle neck is in the portion of the code you posted? Are you sure the SQL is using indexes? How many records are in the file being summarized? Are you running interactive on a system without the enterprise package, thus subject to CFINT? You're not trying to use a open/close a cursor for each row are you. (Might want to post your actual source code instead of pseudo-code) I'd double check the SQL indexes. I've had SQL summary queries over 4.5 million records in a few seconds on a little 270. Charles Wilt -- iSeries Systems Administrator / Developer Mitsubishi Electric Automotive America ph: 513-573-4343 fax: 513-398-1121 > -----Original Message----- > From: rpg400-l-bounces@xxxxxxxxxxxx > [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Brian Piotrowski > Sent: Tuesday, July 19, 2005 10:10 AM > To: RPG programming on the AS400 / iSeries > Subject: Program performance incease ideas > > > Hi All, > > > > I have a portion of one of my programs that does this: > > > > Read Myfile > > Do while not eof(Myfile) > > Read Myfile > > SQLSum = Get the sum of a series of records where somepart > = current part# and somecolour = current part colour > > NewSum = CurrentSum - SQLSum > > Update Myfile > > Read Myfile > > EndDo > > > > I find this process to be very time-consuming, as each SQL > transaction takes about 2-7 seconds to complete. I'm using a > logical file to get the data that is keyed on the part number > and colour as well as only selecting records that have a > status of 3 or 5. > > > > Any ideas on how I could speed this up? The physical file > which it is updating only has 1400 records in it, and it's > been running now for the past ½ hour and has less than ½ the > records processed. > > > > Thanks, > > > > Brian. > > > > -=-=-=-=-=-=-=-=-=-=-=-=-=- > > Brian Piotrowski > > Specialist - I.T. > > Simcoe Parts Service, Inc. > > Ph: 705-435-7814 x343 > > Fx: 705-435-6746 > > bpiotrowski@xxxxxxxxxxxxxxx > > -=-=-=-=-=-=-=-=-=-=-=-=-=- > > > > -- > This is the RPG programming on the AS400 / iSeries (RPG400-L) > mailing list > To post a message email: RPG400-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l > or email: RPG400-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/rpg400-l. > >
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.