Subject Re: [Firebird-Architect] Stored procedures vs Dynamic SQl
Author Ann W. Harrison
vishy anand wrote:

> does firebird saves execution plan both for Sp and dynamic SQL'
> 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.