Subject Re: [firebird-support] execute block or stored procedure?
Author Huan Ruan
On 13 April 2011 06:21, Tom Munro Glass <tom@...> wrote:

> Can someone please enlighten me on the performance implications and
> advantages/disadvantages of using 'execute block' or a stored procedure?
> I'm using a mixture of FB 2.0 and 2.1 at various installations.
> Thanks,
> Tom Munro Glass
Here are what I can think of:

'execute block' is dynamic so you can change your sql without updating the
database, but it's not compiled.

Stored Procedure is an object defined in the database, changing it may
require an exclusive access to the database if other connections have
used/'cached it. It's compiled so will be slightly faster.


[Non-text portions of this message have been removed]