Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023775Openbravo ERP07. Sales managementpublic2013-05-09 10:262013-08-27 10:56
Reporteregoitz 
Assigned Tonaiaramartinez 
PriorityhighSeveritycriticalReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Togorkaion
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023775: The computed columns on c_order table are causing performance problems on the grid
DescriptionThe computed columns on c_order table are causing performance problems on the grid.

*See the following link:

http://wiki.openbravo.com/wiki/How_to_create_a_Computed_Column#Performance_implications [^]
Steps To ReproduceOn an environment with a big amount of data load the sales order grid.
*It takes long to show the data
Proposed SolutionRemove the computed columns
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-05-09 10:26egoitzNew Issue
2013-05-09 10:26egoitzAssigned To => dmiguelez
2013-05-09 10:26egoitzModules => Core
2013-05-09 10:26egoitzOBNetwork customer => Yes
2013-05-09 10:26egoitzTriggers an Emergency Pack => No
2013-05-10 11:17dmiguelezAssigned Todmiguelez => naiaramartinez
2013-05-10 12:07hgbotCheckin
2013-05-10 12:07hgbotNote Added: 0058545
2013-05-10 12:07hgbotStatusnew => resolved
2013-05-10 12:07hgbotResolutionopen => fixed
2013-05-10 12:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0e7d3a929b461f612b336e357f642c9b35586149 [^]
2013-05-10 15:24hgbotCheckin
2013-05-10 15:24hgbotNote Added: 0058566
2013-05-13 15:23naiaramartinezReview Assigned To => gorkaion
2013-05-13 15:23naiaramartinezNote Added: 0058621
2013-05-13 15:23naiaramartinezStatusresolved => closed
2013-05-13 17:30naiaramartinezStatusclosed => new
2013-05-13 17:30naiaramartinezResolutionfixed => open
2013-05-13 17:31naiaramartinezPriorityimmediate => high
2013-05-23 01:32hudsonbotCheckin
2013-05-23 01:32hudsonbotNote Added: 0058795
2013-05-23 01:32hudsonbotCheckin
2013-05-23 01:32hudsonbotNote Added: 0058798
2013-05-28 11:51egoitzTag Attached: Performance
2013-08-27 10:56jonalegriaesarteNote Added: 0060785
2013-08-27 10:56jonalegriaesarteStatusnew => closed
2013-08-27 10:56jonalegriaesarteResolutionopen => unable to reproduce

Notes
(0058545)
hgbot   
2013-05-10 12:07   
Repository: erp/devel/pi
Changeset: 0e7d3a929b461f612b336e357f642c9b35586149
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Fri May 10 12:02:36 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0e7d3a929b461f612b336e357f642c9b35586149 [^]

fixed bug 23733 fixed bug 23775: computed columns performance in c_order and m_inout

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-canvas.js
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0058566)
hgbot   
2013-05-10 15:24   
Repository: erp/devel/pi
Changeset: 2af4fa4502daa9b1023db3d1ab2f19e6ad13fe5a
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Fri May 10 15:22:06 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2af4fa4502daa9b1023db3d1ab2f19e6ad13fe5a [^]

related to issue 23733 related to issue 23775: backout for enabling integration

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-canvas.js
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0058621)
naiaramartinez   
2013-05-13 15:23   
A fix is not going to be done. The wiki is going to be updated to inform that performance can be affected, and if that happens, the fields(invoice status, delivery status) will have to be deactivated/deleted.
(0058795)
hudsonbot   
2013-05-23 01:32   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/97c7f6256af7 [^]

Maturity status: Test
(0058798)
hudsonbot   
2013-05-23 01:32   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/97c7f6256af7 [^]

Maturity status: Test
(0060785)
jonalegriaesarte   
2013-08-27 10:56   
This issue is going to be closed, becuase no change is required. In this case, the wiki has been changed. In the future, platform team will review this functionality to change the way of calculating this type of columns.