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?




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.