[Info-vax] CRTL and RMS vs SSIO

[Arne Vajhøj]

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