[Info-vax] CRTL and RMS vs SSIO

[Lawrence D’Oliveiro]

On Thursday, October 14, 2021 at 9:44:56 AM UTC+13, Dave Froble wrote:

> A simple loop processing an RMS file looking in each record in the field 
> Name for "Dave" can be an open and a couple lines of code. 
> 
> Not such a big difference.

Even on a single table, SQL allows for ORDER BY clauses so the records get returned in an order more suited to the application’s needs. And the ordering can be an expression, not necessary a simple field. Try doing that in RMS.

But beyond that, SQL allows lookups using JOINs on multiple tables, plus of course subqueries -- try implementing that in RMS!