I'm using SqlDependency (sql server 2008 r2) to get notification when data in some tables changes. The query notification is for cache invalidation.
There are three large tables and I want to get changes on a small subset of these tables. These three tables are changing frequently, but the subset is not changing frequently. I have a question about the performance impact.
How does the query notification track changes? Does it effect every query againsts these three tables ( not only for the subset)?
Performance is important in our system. If the sql dependency impacts db performance, we need to find another approach.
As far as I know, the SQL notification will be triggered when the subset changes. But the select statement should meet some requirements, for more detail information, you can refer to the following link:
Detecting Changes with SqlDependency
Creating a Query for Notification
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.