Subject Re: [firebird-support] Views and parameters
Author German Pablo Gentile
Thomas Steinmaurer wrote:

>When you send a CREATE [OR ALTER] PROCEDURE statement
>to the server, it gets parsed, syntactical analyzed,
>optimized and compiled into BLR, like it is done with
>a view. The optimization plan doesn't get stored with
>the SP, so the PLAN is generated every time you will
>use the SP.
Sorry, but if that is true i can't see how SP or views will have a
better execution speed than calling a query from a delphi component. May
be im wrong.
Putting a query inside a SP or a view will have some speed optimization
like running the same query from outside the db?
If yes, why?

Thanks you ver much for you answers