vishy anand wrote:

> does firebird saves execution plan both for Sp and dynamic SQL's..is
> there a performance difference?
> thanks
>

Prepared DSQL statements are saved until explicitly released, but only
within a connection. Stored procedures are prepared on first reference
and retained until the end of the last connection to the database
through the server. The performance differences are hard to quantify,
but the major advantage of stored procedures is that intermediate
results stay on the server.


Regards,


Ann