Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Proactive caching scheduled notification not working Expand / Collapse
Posted Saturday, May 25, 2013 12:22 AM


Group: General Forum Members
Last Login: Monday, March 21, 2016 11:37 AM
Points: 187, Visits: 394
Hi can anyone tell me how scheduled notification works.I tried to work on it but did not understand polling query and processing query concept behind it.
Post #1456764
Posted Sunday, June 9, 2013 5:46 PM



Group: General Forum Members
Last Login: Today @ 2:36 AM
Points: 7,933, Visits: 14,357
The old school way uses polling. The .net framework will check a table to see if it has changed data since the last time it was polled. If it has changed, .net will clear the cached data so the next time its requested it will be retrieved from the database again, instead of using the cached data.

The new school way to do the same thing is to have the database engine notify the .net application by leveraging Event Notifications subsystem within SQL Server. This way as soon as a cached object is invalidated by database activity the application will be notified, I.e. No polling.

There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1461363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse