Re: Embedded SQL - performance question

I decided to just make it RLA via Chain (in this program) instead of
SQL through a service program. This particular program is the only
place where I'm running through the entire file and retrieving this
field from another file.

I still have many uses for the service program procedure. Most of
those are instances where I want the field for a single customer
instead of thousands at a time.

Thanks to all who offered advice, including those who responded
privately offering to really dig into it.



On Thu, May 26, 2011 at 5:12 PM, Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx> wrote:

On 5/26/2011 3:16 PM, CRPence wrote:

    I expect that SQL should be much faster even on a poorly performing
system; almost as fast as the RLA, esp. if the same index is utilized
for both the SQL and RLA.

I've never found a single-record fetch to be anywhere near as fast as
RLA, and I did exhaustive tests; SQL doesn't catch up until the block
size is upped to about 100 records.  I could rerun all those tests, but
until someone shows me some evidence SQL has caught up, I have no reason
to repudiate the old data.

Joe
--
This is the RPG programming on the IBM i / System i (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.