Currently it is a procedure and not a function so that wouldn't work unless
I tweak the backend. Also the query uses 4 table so not sure if result
cache would work well. Great idea though.
On Wed, Feb 24, 2021 at 9:33 PM Oleksandr Denysenko <odenysenko@xxxxxxxxx>
wrote:
Hi.
It will be good to test an effect of enabing Result Cache at least for
mentioned query
вт, 23 февр. 2021 г., 19:18 Jeff Chirco <backseatdba@xxxxxxxxx>:
We have an application that might benefit from using query change
notification. We are a restaurant company, each store has an application
which displays information and refreshes every minute. Majority of the time
the data has not changed and therefore CPU cycles are getting wasted. We
have 400 locations so it contributes to a lot of wasted CPU in my mind. I
want to purpose using query change notification in their .Net application
but I am curious on the DBA side of things. Is there anything to consider
about having 400 and growing change notification requests for the database
to manage? I am assuming each store would have to register its own request.
Any thoughts?
Thanks,
Jeff
