Update the cache/application

[Steffen Loringer]

Hi group,

what is the recommended way to get updates? My application stores some
information in the Page.Application state which are originally created
from another SQL2000Server.
How can I notify my Server with the ASP.NET process if there is a change
of the data on the SQL2000Server?

Thanks
Steffen

 

[Hans Kesting]

Hi group,

what is the recommended way to get updates? My application stores some
information in the Page.Application state which are originally created
from another SQL2000Server.
How can I notify my Server with the ASP.NET process if there is a change
of the data on the SQL2000Server?

Thanks
Steffen

While it doesn't *solve* your problem, at least this will make it
less urgent:

Don't use Application to store this data, but use Cache, along with a
fixed timeout of a few minutes. If there is a lot of traffic on the site,
most will benefit from the cached data and that data is not more than
a few minutes "out of date".

Search for "cachedependency" and "database" for better solutions.


Hans Kesting

 

[Joe Fallon]

I recently implemented database cache invalidation using the ideas on this
site (which appears to be down right now)
www.eggheadcafe.com/articles/20040607.asp

Cached version:
http://216.239.39.104/search?q=cach...icles/20040607.asp+peter+bromberg+cache&hl=en

 

[Natty Gur]

Hi,

1) Use cache version of the article :
http://216.239.59.104/search?q=cache:00LyND65xcgJ:www.eggheadcafe.com/ar
ticles/20030716.asp+cache+update+sql+server+%22asp.net%22&hl=en

2) There is build-in support in ASP.MET 2.0 for such requirement.

Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)52-8888377


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!