Which will be efficient ? Inline query or store procedure...

Anish Kumar

With brief explanation

Advance thanks.....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

10y ago
Accepted answer
i say store procedure ,because it has many advantages
(here SP Means Stored Procedure)
1> SP reuse execution plan..
--when we execute sql queries it has three step process
i>Check syntax of Queries
ii>Complile that Queries
iii>Create Execution Plan(Means Most Efficient Way To Execute Queries)
--But When We Execute Inline Queries Every Time This Three Process Where as
Stored Procedure Only First Time Compile,and Create Execution Plan and
Whenever We Call SP It Only Execute So Save Time For Complile and Make Execution Plan Every Time
2> SP Reduce Network Traffic
--When Inline Queries Have Logic Like 2000 Line so when Execute This Code all Line One By One in Network So More Burden On Server But When We Use SP All Code In DataBase Tool We Pass Only Required Paremeter To Execute SP .So Not A Burden in Server
3>SP Provide Better Security
--When We Use Inline Queries Sql Injection Possible..But In SP Not It Possible
0
Pradeep Sahoo10y ago
stored procedure comes with some major characterstics, as it consists in pre compiled format so the performance increase during dataaccess. incase of simple query it requires to complie again and again as per user request, but here its not required due to precompile format (*compile requires only ones).

due to precompile code resides in database server it provides more security and due to complicated queries can be integrated with one form it is portable also.
0