[Info-vax] CRTL and RMS vs SSIO

[Dave Froble]

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:
>>> On 10/7/2021 1:25 PM, Dave Froble wrote:
>>>> On 10/7/2021 11:50 AM, Arne Vajhøj wrote:
>>>>> On 10/6/2021 10:00 PM, Lawrence D’Oliveiro wrote:
>>>>>> Given that nowadays an SQL-based RDBMS like SQLite can offer full
>>>>>> support for transactions, joins and subqueries (missing only more
>>>>>> multi-user-type features like locking and replication), and yet still
>>>>>> be resource-light enough to fit in your mobile phone, I would say the
>>>>>> time for application developers to be grubbing about in ISAM files is
>>>>>> past.
>>>>>
>>>>> There are still cases where it make sense. RMS index-sequential files
>>>>> are really a NoSQL Key Value Store in modern terminology and
>>>>> they are still used and new ones even being developed (like
>>>>> RocksDB).
>>>>>
>>>>> But the default should change.
>>>>>
>>>>> "use index-sequential file unless good reason to use relational
>>>>> database"
>>>>>
>>>>> =>
>>>>>
>>>>> "use relational database unless good reason to use
>>>>> index-sequential file"
>>>>
>>>> I'd suggest there should not be a "default".  Rather, make good
>>>> thoughtful decisions.  Have valid reasons for any decisions or choices.
>>>
>>> Fair enough.
>>>
>>> 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.
>
> Arne
>

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.

-- 
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