[Info-vax] CRTL and RMS vs SSIO

[Jan-Erik Söderholm]

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.