Hi

I have been told is sql an interpreted language?

Is this the case and if so does this mean that the sql script is read
every time it is applied to a record?

or

Does it mean that the sql script is read in once and converted to a
"pcode" (like vb used to be) format and then applied to all records
specified?

Can the sql scripts in FB be "compiled" for either better performance
or improved security?

kind regards

Peter