Subject RE: [Firebird-Architect] Re: Stored procedures vs Dynamic SQl
Author Rick Debay
When a stored procedure is first executed, the execution plan for each
statement in it is saved until the database is restarted or the last
connection closed.
When an SQL statement is executed, the plan is not saved, although the
statement may be cached on the client side (e.g. Jaybird's statement

-----Original Message-----
[] On Behalf Of
Sent: Thursday, July 14, 2005 1:44 AM
Subject: [Firebird-Architect] Re: Stored procedures vs Dynamic SQl


What I meant was.. SQL server 2000...saves execution plan of stored
procedures as well as Dynamic SQL.. what does Firebird do? We r
developing an application which uses client(smart in .net) and server in
.net, and Firebird as database(WAN netwrok using optical fibres).I would
like to go for Dynamic SQL(using LLBgen like product) I feel
maintaing stored procedures is a painful job thanks

--- In, "Leyne, Sean" <Sean@B...>
> > does firebird saves execution plan both for Sp and dynamic
> > there a performance difference?
> Please clarify your definition of 'saves'.
> Sean

Yahoo! Groups Links