Issue: The bellow query is top in our database server.
Need help identify the opportunity is this query is cached in latest 6.2 or it is an opportunity improve latest version.
can you help validate this issue ?
Ready, implemented cache in MReference and MRefTable
We tested in last 24h in production. Result: approx 2mill queries.
IMHO i assume the caching not working yet.
(total_time / 1000 / 60)::decimal as total_minutes,
(total_time/calls)::decimal as average_time,
-- WHERE Query ilike '%1001231%'
ORDER BY 1 DESC
Hi , could be something in your custom code using new X_AD_Reference or new MReference