Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
Optimize redundant sproc calls
Rp Singh
Sep 1 2016 4:20 AM
243
Reply
Consider this scenario -
SP - dbo. executeMe
the code is as -
page1.cs
function abc()
{
.....statements
execdbo.executeMe
//letssay
values--
storeresult--
}
function cde()
{
.....statements
execdbo.executeMe
//letssay
values--
storeresult--
}
function efg()
{
.....statements
execdbo.executeMe
//letssay
values--
storeresult--
}
I have another page lets say
page2.cs
which has two functions which aslo executes the
function mno()
{
.....statements
execdbo.executeMe
//letssay
values--
storeresult--
}
function pqr()
{
.....statements
execdbo.executeMe
//letssay
values--
storeresult--
}
Now, how i can execute the function only once and get the values all the time.
( USE THE 1ST EXECUTED STATEMENT) all the time without invoking the sp again and again. Causing redundant sp reduces the optimization.
Solutions are welcome..
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
stored procedure for filters
SQL server log shipping error when copying secondary server