Loading

Optimize redundant sproc calls

Optimize redundant sproc calls

Ms_ Dev

Ms_ Dev

10y849

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

4 Replies

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

Nitin Sontakke10y ago
Accepted answer
The optimization, of course, works if several calls are made during a single page life cycle (in case of asp.net, i mean).
You haven't given sufficient implementation details, however, just to give you an idea, all you have to do is cache the results in a variable which doesn't go out of scope. You can have a static method of a static class.
The sample code would look as follows:
function getResult()
{
var resultTable // data table, list view or any other appropriate data structure to hold the result;
if( resultTable == null) // This happens when it is a first call.
{
fill result table with sp execution
}
return resultTable // second time onwards, only this happens!
}
Hope it helps!
Nitin Sontakke10y ago
Of course, you can. The technique is same, though!
Ms_ Dev10y ago
@Nitin Can't i use properties by anymeans to do the task ?
Manas Mohapatra10y ago
If you are using this SP in WebApplication then you can use Cache concept.

Call the SP and get the result. Then store the value in Cache object.

Cache["tmpCach"] = result;

or

if you are using different than web, then you can use a static variable to load the SP data.

public static List tempList = new List() ;
tempList = result;