Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0015362 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2010-12-02 19:16 | 2010-12-16 22:16 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.50MP25 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | abe749f609f8 | ||||
| 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 | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0015362: Remove around 130.000 duplicate db-queries from Wad to speedup wad runtime around 40s-1min | |||||||
| Description | WadUtility.getWadControlClass is an utility method to return an instance of the corresponding WadControl for a pair of parentReference & subReference. One step in this is to lookup the java-classname for this pair in the database. The total number of queries done for this in a typical compile.complete is around 13000. The total number of unique parentReference/subReference pairs is around 350. Using a small cache for this lookup can remove most of those 130000 queries which leads to a speedup of Wad part of an compile.complete of around 40s to 1min (depending on the system). | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0033019) hgbot (developer) 2010-12-02 19:22 |
Repository: erp/devel/pi Changeset: abe749f609f8c07185a630e2f800d3995ae7e3fc Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Thu Dec 02 19:19:21 2010 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/abe749f609f8c07185a630e2f800d3995ae7e3fc [^] Fixed 15362: Speedup wad by caching many repeated queries. Remove nearly 130.000 db-queries by using a small cache of around 350 entries --- M src-wad/src/org/openbravo/wad/WadUtility.java --- |
|
(0033025) hudsonbot (developer) 2010-12-03 01:56 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/abe749f609f8 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/75b773c7562f [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19066.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-12-02 19:16 | shuehner | New Issue | |
| 2010-12-02 19:16 | shuehner | Assigned To | => shuehner |
| 2010-12-02 19:16 | shuehner | Modules | => Core |
| 2010-12-02 19:22 | hgbot | Checkin | |
| 2010-12-02 19:22 | hgbot | Note Added: 0033019 | |
| 2010-12-02 19:22 | hgbot | Status | new => resolved |
| 2010-12-02 19:22 | hgbot | Resolution | open => fixed |
| 2010-12-02 19:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/abe749f609f8c07185a630e2f800d3995ae7e3fc [^] |
| 2010-12-03 01:56 | hudsonbot | Checkin | |
| 2010-12-03 01:56 | hudsonbot | Note Added: 0033025 | |
| 2010-12-14 16:37 | alostale | Status | resolved => closed |
| 2010-12-14 16:37 | alostale | Fixed in Version | => 2.50MP25 |
| 2010-12-16 22:16 | anonymous | sf_bug_id | 0 => 3138804 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |