Performance Tuning
I have a grid with load of 1000 's of records
and i need to send the 1000's of records to Database for some update operation.
For this case what would be the best way to handle this scenario?
Thanks ......
and i need to send the 1000's of records to Database for some update operation.
For this case what would be the best way to handle this scenario?
Thanks ......
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avodah
Without more specific information I am assuming that you want to avoid a loop what call a stored procedure or the likes to update each record one at a time. I would then suggest that you can use a stored procedure that takes the data to be updated and parse within the stored procedure and transfer the loop there. This reduces the overhead of continuous calling the stored procedure.
do you need further assistance here?
ASP.NET
The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications
128K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
