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

Show:
Nicolas Micoud
November 18, 2019, 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

Assignee

Diego Ruiz

Reporter

Norbert Bede

Labels

None

Tested By

None

Fix versions

Priority

Major
Configure