Re: Performance - RPG vs Cobol

It could use SQL, it could use RLA, depends on how you configure the model. I have only used RLA. There are several patterns that deal with subfiles, and several that deal with individual records. You can choose whether it loads the subfile one page at a time, or the entire subfile.

Mark Murphy
Atlas Data Systems
mmurphy@xxxxxxxxxxxxxxx


-----Nathan Andelin <nandelin@xxxxxxxxx> wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Nathan Andelin <nandelin@xxxxxxxxx>
Date: 05/31/2017 02:37PM
Subject: Re: Performance - RPG vs Cobol


oops, forgive my typo on COBOL.


On Wed, May 31, 2017 at 12:35 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

It has been more than a couple decades since I've reviewed Synon 2E
models. Aren't we talking about BREAD functions (Browse, Read, Edit, Add,
Delete) for each file?

Out of those operations, wouldn't Browse be the most resource intensive?
All the other operations are on individual records, which don't require
much CPU.

That begs the question, do 2E models utilize SQL under the covers for
dynamically generating filtered lists, for browsing? For that matter, does
2E use SQL for read, edit, add, and delete? Or are the models based
entirely on RPG and COBAL RLA operations?