Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0023775 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | critical | always | 2013-05-09 10:26 | 2013-08-27 10:56 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | naiaramartinez | |||||||
| Priority | high | Resolution | unable to reproduce | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 0e7d3a929b46 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | gorkaion | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0023775: The computed columns on c_order table are causing performance problems on the grid | |||||||
| Description | The 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 Reproduce | On an environment with a big amount of data load the sales order grid. *It takes long to show the data | |||||||
| Proposed Solution | Remove the computed columns | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0058545) hgbot (developer) 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 (developer) 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 (developer) 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 (developer) 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 (developer) 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 (reporter) 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. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2013-05-09 10:26 | egoitz | New Issue | |
| 2013-05-09 10:26 | egoitz | Assigned To | => dmiguelez |
| 2013-05-09 10:26 | egoitz | Modules | => Core |
| 2013-05-09 10:26 | egoitz | Triggers an Emergency Pack | => No |
| 2013-05-10 11:17 | dmiguelez | Assigned To | dmiguelez => naiaramartinez |
| 2013-05-10 12:07 | hgbot | Checkin | |
| 2013-05-10 12:07 | hgbot | Note Added: 0058545 | |
| 2013-05-10 12:07 | hgbot | Status | new => resolved |
| 2013-05-10 12:07 | hgbot | Resolution | open => fixed |
| 2013-05-10 12:07 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0e7d3a929b461f612b336e357f642c9b35586149 [^] |
| 2013-05-10 15:24 | hgbot | Checkin | |
| 2013-05-10 15:24 | hgbot | Note Added: 0058566 | |
| 2013-05-13 15:23 | naiaramartinez | Review Assigned To | => gorkaion |
| 2013-05-13 15:23 | naiaramartinez | Note Added: 0058621 | |
| 2013-05-13 15:23 | naiaramartinez | Status | resolved => closed |
| 2013-05-13 17:30 | naiaramartinez | Status | closed => new |
| 2013-05-13 17:30 | naiaramartinez | Resolution | fixed => open |
| 2013-05-13 17:31 | naiaramartinez | Priority | immediate => high |
| 2013-05-23 01:32 | hudsonbot | Checkin | |
| 2013-05-23 01:32 | hudsonbot | Note Added: 0058795 | |
| 2013-05-23 01:32 | hudsonbot | Checkin | |
| 2013-05-23 01:32 | hudsonbot | Note Added: 0058798 | |
| 2013-05-28 11:51 | egoitz | Tag Attached: Performance | |
| 2013-08-27 10:56 | jonalegriaesarte | Note Added: 0060785 | |
| 2013-08-27 10:56 | jonalegriaesarte | Status | new => closed |
| 2013-08-27 10:56 | jonalegriaesarte | Resolution | open => unable to reproduce |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |