Update the cache/application

  • Thread starter Thread starter Steffen Loringer
  • Start date Start date
S

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
 
Steffen Loringer said:
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
Click to expand...

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
 
Back
Top