Skip to:

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

Improving performance on InfoWindows

Description

We've been finding several problems on performance for Info Windows when the amount of data is considerable big.

Environment

None

Attachments

3

Activity

Show:

Carlos Ruiz August 19, 2015 at 7:55 PM

This is being fixed with

Carlos Ruiz March 18, 2014 at 1:10 AM

Documenting a finding.

Found a bug on the InfoPanel from adempiere361 and previous.

The testCount method executes a SELECT COUNT and doesn't take into account the access SQL for the selected columns, this can lead to different number of rows in the count vs the real data.
i.e. in old product window having a record access filter for m_pricelistversion_id the testCount won't add the filter but the dataSQL will add the filter leading to index error on rendering the info window lines

NOTE this behavior cannot be reproduced in vanilla iDempiere, but applying the attached "IDEMPIERE-1459patch" could open this problem again, so I'm annotating here this consequence to take into account.

Juliana Corredor T. November 25, 2013 at 11:05 PM

I attached an improvement for InfoWindow please peer review and include thanks

Juan David Arboleda Ruiz October 23, 2013 at 4:52 PM

I attached an improvement for infoProduct window which includes the patch generated by Carlos R ("IDEMPIERE-1459_views.patch")

Carlos Ruiz October 23, 2013 at 1:43 PM

Attaching IDEMPIERE-1459_views.patch with two view improvements (it requires adding a migration script for that) and M_PRODUCT_STOCK_V.sql requires a change on InfoProductWindow to exploit the performance improvement.

Duplicate

Details

Assignee

Reporter

Components

Affects versions

Priority

Created October 22, 2013 at 11:12 PM
Updated October 1, 2015 at 5:02 PM
Resolved August 19, 2015 at 7:55 PM