Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0015362 | Openbravo ERP | A. Platform | public | 2010-12-02 19:16 | 2010-12-16 22:16 |
|
| Reporter | shuehner | |
| Assigned To | shuehner | |
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 2.50MP25 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| 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). |
| Steps To Reproduce | |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| 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:16 | shuehner | OBNetwork customer | => No |
| 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 |