Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0019895 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| design defect | [Openbravo ERP] I. Performance | major | always | 2012-02-28 00:42 | 2012-04-01 20:39 | |||
| Reporter | fleroux | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 3.0MP10 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | f1158e744da8 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6 | |||
| OS Version | Database version | 8.4 | Ant version | 1.7 | ||||
| Product Version | 3.0MP8 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | Google Chrome, Mozilla Firefox | |||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0019895: CPU spike during invoice header click | |||||||
| Description | When opening the invoice tab in grid mode I navigate to click a record in the grid which then results in CPU utilization spikes of 10-30%. The result of this in a concurrent scenario would be that multiples of 5-10 users will exhaust the CPU. | |||||||
| Steps To Reproduce | See above | |||||||
| Proposed Solution | Looked at the FIC component and currently focusing on the computevalues area which appears to cause the CPU overhead | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0046237) hgbot (developer) 2012-03-09 16:16 |
Repository: erp/devel/pi Changeset: f1158e744da895f9f41179cd70b48ed8152544b5 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Fri Mar 09 16:15:21 2012 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/f1158e744da895f9f41179cd70b48ed8152544b5 [^] Fixed issue 19895. Done several changes to improve the performance of the FIC and reduce the server load (specially when the user selects a record in grid): - Cached the whole Tab instance in the FIC (not only its related objects (fields, auxiliary inputs, ...)) to avoid an additional (and expensive) query - Removed the OBCriteria for the attachments and notes. They've been replaced by an OBQuery and a HQL Query to reduce computation time. - Replaced the UsageAudit call in each DataSourceServlet request by the non-dal version (which greatly reduces the computation cost) - Added a constructor in the DynamicExpressionParser class so that an instance of ApplicationDictionaryCachedStructures can be passed if it is available. This avoids having to do an expensive call to Weld when the FIC uses the DynamicExpressionParser. --- M modules/org.openbravo.client.application/src/org/openbravo/client/application/DynamicExpressionParser.java M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/ApplicationDictionaryCachedStructures.java M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/FormInitializationComponent.java M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServlet.java --- |
|
(0046822) alostale (manager) 2012-03-28 13:03 |
Executed test: -Attachments still work and are properly displayed -Notes still work and are properly displayed |
|
(0047079) hudsonbot (developer) 2012-04-01 20:39 |
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/640de9acc2d5 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-02-28 00:42 | fleroux | New Issue | |
| 2012-02-28 00:42 | fleroux | Assigned To | => shuehner |
| 2012-02-28 00:42 | fleroux | Web browser | => Google Chrome, Mozilla Firefox |
| 2012-02-28 00:42 | fleroux | Modules | => Core |
| 2012-02-28 08:16 | iperdomo | Assigned To | shuehner => agaldos |
| 2012-02-28 08:32 | alostale | Assigned To | agaldos => alostale |
| 2012-02-28 08:32 | alostale | Web browser | Google Chrome, Mozilla Firefox => Google Chrome, Mozilla Firefox |
| 2012-02-28 08:32 | alostale | Type | defect => design defect |
| 2012-02-28 08:32 | alostale | Relationship added | related to 0019896 |
| 2012-03-09 16:16 | hgbot | Checkin | |
| 2012-03-09 16:16 | hgbot | Note Added: 0046237 | |
| 2012-03-09 16:16 | hgbot | Status | new => resolved |
| 2012-03-09 16:16 | hgbot | Resolution | open => fixed |
| 2012-03-09 16:16 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/f1158e744da895f9f41179cd70b48ed8152544b5 [^] |
| 2012-03-26 15:13 | alostale | Relationship added | related to 0020102 |
| 2012-03-27 13:44 | alostale | Relationship added | related to 0020124 |
| 2012-03-28 13:03 | alostale | Note Added: 0046822 | |
| 2012-03-28 13:03 | alostale | Status | resolved => closed |
| 2012-03-28 13:03 | alostale | Fixed in Version | => 3.0MP10 |
| 2012-04-01 20:39 | hudsonbot | Checkin | |
| 2012-04-01 20:39 | hudsonbot | Note Added: 0047079 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |