Skip to main content
Question

Micro Cache performance in quick reports

  • June 21, 2024
  • 0 replies
  • 35 views

Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 44 replies

During the process of upgrading from Apps 9 to Cloud we have noticed a number of Get- apis have been updated to use a micro-cache method rather than a sub query:

https://docs.ifs.com/techdocs/23r2/060_development/027_base_server_dev/060_performance/010_plsql-performance/001_micro_cache/#micro_cache_micro_cache_array_implementation

 

The performance hit on a quick report using these apis as been quite dramatic. Is there a was to speed these calls up? We obviously have the option to put sun-queries direct in the report but there could be lots of them.

 

Thanks.

0 replies

Be the first to reply!