Caching Candidate: AD_Table

Description

Version: 3.1

Issue: The bellow query is top in our database server.

i found another query: SELECT AD_Table_ID FROM AD_Table WHERE tablename = $1

Need help to identify the opportunity is this query is cached in the latest 6.2 or it is an opportunity to improve the latest version.

Carlos Ruiz ​can you help validate this issue

norbert

Environment

None

Activity

Nicolas Micoud November 18, 2019 at 4:53 PM

Hello,

My 2 cents here : there is already a cached method for that purpose :
org.compiere.model.MTable.get(Properties, String)

Regards,

Nicolas

Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created November 18, 2019 at 11:10 AM
Updated May 12, 2020 at 10:55 AM
Resolved November 18, 2019 at 8:00 PM