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: