[Info-vax] CRTL and RMS vs SSIO

[Dave Froble]

On 10/13/2021 12:42 PM, Jan-Erik Söderholm wrote:
> Den 2021-10-13 kl. 17:09, skrev Dave Froble:
>> On 10/13/2021 10:04 AM, Arne Vajhøj wrote:
>>> On 10/12/2021 9:52 PM, Dave Froble wrote:
>>>> On 10/12/2021 5:10 PM, Arne Vajhøj wrote:
>>>>> On 10/12/2021 4:42 PM, Dave Froble wrote:
>>>>>> On 10/12/2021 3:55 PM, Arne Vajhøj wrote:
>>>>>>> But the money math has changed.
>>>>>>>
>>>>>>> I would say that over the last 30 years:
>>>>>>>
>>>>>>> RDBMS license cost changed from expensive to free options available
>>>>>>>
>>>>>>> RDBMS hardware resource cost changed from expensive to insignificant
>>>>>>>
>>>>>>> writing and maintaining code to manage IDX file cost is more or less
>>>>>>> constant
>>>>>>
>>>>>> Are you suggesting writing and maintaining code for RDBMS is any
>>>>>> different?
>>>>>
>>>>> You need much less code because the database software does
>>>>> so much.
>>>>>
>>>>> It is a tradeoff - you write much less code but the generic code
>>>>> in the RDBMS use more CPU and memory.
>>>>
>>>> Excuse me, I'm just a dummy, come down out of the hills.  But:
>>>>
>>>> 1) Open file
>>>> 2) Access data
>>>> 3) Do some work
>>>> 4) Write/Update data
>>>> 5) Done
>>>>
>>>> and
>>>>
>>>> 1) Access database
>>>> 2) Access data
>>>> 3) Do some work
>>>> 4) Write/Update data
>>>> 5) Done
>>>>
>>>> Guess I don't see much difference.
>>>
>>> That is because you describe *what* is being done not *how* it is done.
>>>
>>> In general you can expect:
>>>
>>> data maintenance - replacing a lot of application code with few lines of
>>> SQL
>>
>> You claim that, but I just don't see it.
>>
>>> applications with simple queries - slightly less code
>>>
>>> application code with complex queries - a lot less code
>>>
>>> adhoc just get some numbers - replacing a lot of application code with
>>> few lines of SQL
>>
>> Don't see that.
>>
>> Also, I've noticed that doing some things with SQL can be much more
>> complex.
>>
>>
>
> It is not clear what you have or haven't seen, but your conclusions
> are a bit weird. It is so much easier to do data maintanance and
> adhoq queries aginst a typical SQL database (such as Rdb) than to
> try that against RMS data files. You are just completely wrong.

Ad hoc inquiries I'll give you.  RDBMS is great for that.

But that wasn't in the discussion.  Arne claimed that it took code to 
use an RDBMS, and with some exceptions, that just isn't always so.

Yes, "SELECT * Where Name Like "Dave" is rather simple.  But one must 
still attach to the database.  Request a Recordset. and so on.

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.

-- 
David Froble                       Tel: 724-529-0450
Dave Froble Enterprises, Inc.      E-Mail: davef at tsoft-inc.com
DFE Ultralights, Inc.
170 Grimplin Road
Vanderbilt, PA  15486