Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: Thursday, April 03, 2014 1:30 AM
Points: 113, Visits: 207
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 09, 2013 5:46 PM



Group: General Forum Members
Last Login: Yesterday @ 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1461363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse