Re: Database I/O Modernization

On Fri, Sep 15, 2017 at 12:38 PM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

I thought we were discussing your scenario.

I raised the scenario of splitting a master file into multiple files, and
the affect of that on applications.

You raised a scenario of essentially "what if there happened to be some
programs that used only a subset of fields that weren't part of the split".
How likely might that be?

I think there is a good case to be made for externalizing SQL into views.
Less of a case for hard-coding SQL into HLL interfaces. And even less of a
case when fetching rows from SQL result sets into data structures - if your
main point is "decoupling".

If you do that in order to streamline code, or for programmer productivity
purposes, that would be another matter. People should have the option of
weighing the trade-offs.