Re: query change notification

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_at_gmail.com>:

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

--
http://www.freelists.org/webpage/oracle-l