Last post Oct 04, 2013 01:10 AM by yousufctec
Sep 20, 2013 10:12 AM|sairam89zGh|LINK
I have situation like these...In the grid view...When click on row editing...I have to Call One Store Procedure repeatedly...What‘s I am thinking …. Repeatedly calling “Store Procedure “…….More time Consuming ... … Instead of calling store Procedure
……Passing Some Set Of values to store Procedure at the End Of block Based On That ..That values Stored In “Temporary Table” ….to access that table rows Form Temporary Table ..Calling Store Procedure repeatedly..Until table values is Exhausted… Backed
end so it is less Time Consuming … is it Possible to do …these thing..If Possible what Of steps We need to ..Follow to achieve These Concept.
Ex:- my Explanation Question …..
Suppose I have 10 Time Calling “Store Procedure” ..It is Very time taking so..I don’t like Calling Above Method…
What I am Thinking pass values ….in the from of sets... These set of values Is stored in a table or List …Pass that Entire value set to the store Procedure …Now Take one By one Input set Calling “Store Procedure” ..
Here we calling Only Once Form Front end application So..We reduce lot of time here..So performance Better...But I have doubt about that …is these really possible to achieve .
anyone Know These type of technique can replay me.
Oct 04, 2013 01:10 AM|yousufctec|LINK
Use a delimiter and pass the parameter and receive the parameter as text type from database and again separate it with that delimiter in loops and perform operation..