Tuesday, October 7, 2008

Improving Website Performance - Part 3

Retrieve multiple resultsets from database
Design the app in such a way that the requestpath to database is very minimal. Each of the roundtrip decreases the number of requests per second the app can serve. Make sure to return the multiple resultset in single database request. It will enhance the performance as well as the scalability of the application.

Restrict the amount of data retrieved
The sql query or the stored procedure can be designed to restrict the number of results retrieved from the database. In other words the business logic should reside in the stored procedure or Sql query which might constraint a number of results returned from database.

No comments: