[Info-vax] Coding with/without RDBMS

[Lawrence D’Oliveiro]

On Saturday, October 23, 2021 at 9:24:27 PM UTC+13, Jan-Erik Söderholm wrote:
>
> Again, there is no major difference in how SQL is handled in Cobol 
> than in any other compiled language. Scripting languages might have 
> some other run-time mangling of SQL commands, but that can be done 
> from Cobol also using a dynamic-SQL interface. But that has worse 
> performance since the SQL has to be processed and "compiled" at each 
> call.

The overhead of “compiling” SQL at runtime is not a concern on modern hardware. The bulk of the overhead lies very much in the actual database I/O.

And modern dynamic languages make a lot of things easy to do that are difficult, or just about impossible on COBOL. I have given some examples of this; I can repeat them if you like.