How to avoid multiple database request to improve performance

It is not good to execute multiple db request for loading single page. Review your database code to see if you have request paths that go to the database more than once. Each of those round-trips decreases the number of requests per second your application can serve. By returning multiple resultsets in a single database request, you can cut the total time spent communicating with the database.

In order to improve performance you should execute single stored proc and bring multiple resultset in to single db request.

Click here for more information
How to avoid multiple database request to improve performance How to avoid multiple database request to improve performance Reviewed by ManaBlog4All on 9:53 PM Rating: 5

No comments:

Powered by Blogger.