how to reduce loading time in asp.net webapplication

Question

How to reduce loading time while the asp.net application connected with database

Manas Mohapatra · Answer

Hi Fareeda Please find below outlines for asp.net-database optimization: 1. Use connection pooling concept in your connection string 2. Use database stored procedure instead of multiple sqlcommand 3. Make sure that the machine should sufficient memory(RAM) where database is installed 4. Make sure that you closing connection after Database operations Moreover you can follow below link: http://an-it-solution.blogspot.in/2008/12/tips-for-database-optimizationoperation.html