Data Caching in ASP.NET

Question

We store the location information in a table. Numbers of records are over four thousand. This table structure is self-recursive. In our web project, we use dropdownlist control to populate all these locations. We got performance slow problem. So googling about Caching, we consider to use Data Caching with Sql Dependency. However, not found yet a full-covered sample in .NET 2.0 and SQL Server 2005 or 2008. Please share me.

Before you start caching your data, have you checked where the performance issue is? — Kim R
– Kim R, Commented Dec 15, 2010 at 13:20
We're still finding where the issue is? Because at our office, loading time is around 3 sec. But at client side, it's over 7 sec. — soclose
– soclose, Commented Dec 16, 2010 at 6:07
another case - we use a third party control - multi-column drop down. At every post back, its datasource is auto nothing. so I code the 1st time from Database, the rest from viewState. here which way is better to performance issue? — soclose
– soclose, Commented Dec 16, 2010 at 9:45

Binoj Antony · Accepted Answer · 2010-12-02 09:50:20Z

3

Here are two articles with full details with sample code on working with SqlDependency Caching using Sql Server 2005 and ASP.NET 2.0

answered Dec 2, 2010 at 9:50

Binoj Antony

16.3k25 gold badges92 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Data Caching in ASP.NET

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related