tag:blogger.com,1999:blog-5874979429188093780.post8920155021261409042..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: Auto Refresh for ADF BC Cached LOVAndrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5874979429188093780.post-26649737927517476762015-11-12T02:22:50.649+01:002015-11-12T02:22:50.649+01:00Well, I guess nothing comes for free :) Obviously ...Well, I guess nothing comes for free :) Obviously DB will have more work to do. But in general, change notification is very scalable, we are using it in heavy load systems without scalability issues.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-25188934666180315322015-11-12T02:08:18.547+01:002015-11-12T02:08:18.547+01:00Hi Andrejus
Is there any performance impact by gr...Hi Andrejus<br /><br />Is there any performance impact by granting change notification privilege to database user.<br /><br />I am also looking for options to refresh view instances in shared application module, without the database user having notification privileges.<br /><br />Mohammed Tanveerhttps://www.blogger.com/profile/12791205519183202617noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-42981670317592981772015-09-19T10:35:03.097+02:002015-09-19T10:35:03.097+02:00You should use cached LOV's for static data on...You should use cached LOV's for static data only. In general to answer your question, I would need to review your application.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-87056882739076870262015-09-19T00:46:07.648+02:002015-09-19T00:46:07.648+02:00We have 500+ LOVs in our application. Is it good t...We have 500+ LOVs in our application. Is it good to apply this pattern on all those LOVs? I was more concern about the performance of the application after applying this on all 500+ LOVs.Anonymoushttps://www.blogger.com/profile/09577502869688523143noreply@blogger.com