× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. May 2005

RE: Help improve performance of RPG program - Long Post

Alan,

I just finished another project that writes directly to the IFS. I may try the same process with this one because that was very easy and efficient. I'll let you know if that improves things any...

Why so many records to the Data Warehouse? That's the very question I've asked a hundred times in various meetings. I wanted to journal the files or place triggers on them to send only the changes but they would not hear of it. They wanted EVERY record from the files that they've identified (20 daily and 55 monthly). Two of the files have 1.5 million + records and 1 has 500,000+. The other files are "manageable" with the current program.

Rich...

----Original Message Follows----
From: Alan Campin <Alan.Campin@xxxxxxx>
Reply-To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Subject: RE: Help improve performance of RPG program - Long Post
Date: Tue, 24 May 2005 13:54:35 -0700

Why not write directly to the IFS and have them pick it up from the IFS or FTP from the IFS? Writes to IFS are very fast.

Also, why so many records to the data warehouse? In other words, could you summarize the data?

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


As an Amazon Associate we earn from qualifying purchases.

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

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.