Proactive caching scheduled notification not working

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply