[Info-vax] CRTL and RMS vs SSIO

[Arne Vajhøj]

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

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

Arne