hi all,
I'm using SqlDependency (sql server 2008 R2) to get notification when data in some tables changed. The query notificatin 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.
How does the query notification track changes? Does it effect every query againsts these three tables (not only for the subset)?
Performance is a major concern in our system, if the sql dependency impacts the performance, we need to find another approach.
best wishes
William