when the stored procedure contains statements which dynamically change
the stored procedure. Input and output parameters, have no effect on the
execution plan, they are pre-cached also even if they are not used.
I have increased application performance drastically, by using stored
procedures and putting some application logic in them. Recursive tree's,
workflow, versioning, all handled by stored procedures and they only
require one call from within CFML instead of the usally 10+ db calls.
You have to experience the improvements in speed, to believe the
importancy of stored procedures and you got to have the nerve to put
some of the application logic into a stored procedure.
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
