Re: query change notification

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