Home » Tip Bank

Language: ASP.NET
Expertise: Beginner

May 23, 2005

To achieve faster performance, enable the caching property in your database-driven data source control (this is applicable only for ASP.NET 2.0).

<asp:SqlDataSource CacheDuration=600 EnableCaching=true ID="SqlDataSource1" Runat="server">
</asp:SqlDataSource>

CacheDuration indicates the number of seconds the data is be kept in the memory. When that time is up, the sqldatasource control fetches the data from the database. You can also set the CacheDuration to Infinite.

Note that the SqlDataSource control is used here as an example. This is applicable for all database driven data source control.