AD_Reference Caching validation
Description
Version: 3.1
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 ?
norbert
Environment
None
Activity
Show:
Carlos Ruiz
November 13, 2019, 10:36 AM
Ready, implemented cache in MReference and MRefTable
Norbert Bede
December 3, 2019, 9:28 PM
We tested in last 24h in production. Result: approx 2mill queries.
IMHO i assume the caching not working yet.
SELECT
calls,
(total_time / 1000 / 60)::decimal as total_minutes,
(total_time/calls)::decimal as average_time,
query
FROM pg_stat_statements
-- WHERE Query ilike '%1001231%'
ORDER BY 1 DESC
LIMIT 100;
Â
Carlos Ruiz
December 4, 2019, 4:03 PM
Hi , could be something in your custom code using new X_AD_Reference or new MReference
Regards,
Carlos Ruiz
