Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Cache getLookupInfo method to avoid multiple queries execution

Description

executes

everytime. I believe for each column_id retrieved values would remain same. Can we cache them?

I am using older version of idempiere, so could not create patch, however is the code sample for caching and attached is the DTO class.

MLookupFactory.java

Environment

None

Attachments

1

Activity

Show:

Pritesh Shah February 9, 2018 at 9:15 PM

Perfect, thank you!

Carlos Ruiz February 9, 2018 at 9:13 PM

Hi ,

I solved the issue in a different way using the actual caches from column and valrule.

I also noticed and fixed non-cached queries on GridTab.setLinkColumnName, MLookupFactory.getListIdentifiers and WEditorPopupMenu

Regards,

Carlos Ruiz

Fixed

Details

Assignee

Reporter

Priority

Created February 8, 2018 at 11:40 PM
Updated April 4, 2018 at 10:22 PM
Resolved February 9, 2018 at 9:13 PM