Subject Re: Stored procedures vs Dynamic SQl
Author women_lover_best

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

--- 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