Oracle live data updates for frequently updated table: poll or CQN?
0
votes
1
answer
288
views
My team is looking at getting live updates from our Oracle database from a frequently updated table. I have discovered [CQN](https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_cqn.htm#CHDJBFEC) and configured a test environment to use UTL_HTTP to POST to a webhook when the table changes. However, in the 'Best Practices' section of the documentation for CQN:
> Register few queries—preferably those that reference objects that rarely change.
And in [other articles](https://dzone.com/articles/demo-oracle-database-continuous-query-notification) for instance:
> if you know the table is subject to a lot of change, then your apps will be better off simply polling the table and avoiding any CQN overhead. Note that CQN was designed to be used for relatively infrequently updated tables.
CQN had seemed like a great solution until I read these disclaimers. The table we want to get live updates from has about 1000 inserts per second during busy time bursts.
The alternative to CQN appears to be polling to query this table every second. Is polling like that the best solution for getting live updates from a table, or is there something I am missing? I am working with Oracle 11g.
Thank you.
Asked by Aaron B
(103 rep)
Jul 29, 2020, 06:38 PM
Last activity: Jul 30, 2020, 03:28 AM
Last activity: Jul 30, 2020, 03:28 AM