[Info-vax] Oracle on VMS

[Arne Vajhøj]

On 11/19/2016 7:33 PM, Jan-Erik Soderholm wrote:
> I have found that many "simpler" databases uses a "Dynamic SQL"
> interface, that is, the SQL statements are sent as-is to the database
> for processing at run-time.

For databases where access is network only, then sending SQL
is rather obvious.

>                         That can be done with Rdb also, but you
> get much worse performance of course, when all your SQL has to be
> "compiled" at each call. Yes, in many cases there are way to prepare
> an SQL statement and then call it multiple times, but it still has to
> be prepared (syntax checked and compiled) each time the EXE runs.

Not really.

Most modern databases cache execution plans.

Arne