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

Assignee

Carlos Ruiz

Reporter

Norbert Bede

Labels

None

Tested By

Norbert Bede

Components

Affects versions

Priority

Major
Configure