Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011055 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | have not tried | 2009-10-20 17:32 | 2009-11-19 00:00 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 9be52538e37f | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | 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 | 0011055: export.database and update.database could be 1min faster always | |||||||
| Description | The two steps: Reading tables Reading functions each take about 30s use non optimized sql statements which could be easily made faster (around 1-2seconds each perhaps) | |||||||
| Proposed Solution | Example: reading functins Change the upper(proname) = upper(?) to a simple proname = ? from the qeuries reading the function derails and also remove the upper(proname) from the query reading the list of functions (to match the case). Add an toUppercase when storing the procedure name into the Function object to not change behavior of other java dbsm code. Apply the same idea to reading tables | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0021223) shuehner (administrator) 2009-10-20 17:32 |
Note: Speedup tested on postgres only, check if a similar change is useful in the oracle specified sql's |
|
(0021735) shuehner (administrator) 2009-11-11 18:45 |
The Read tables part of the theoretical speedup cannot be done easily. The the "Reading functions..." takes about 0.5s on oracle and about 30s on postgres. The 30s on postgres can be speed up to 0.5 |
|
(0021736) hgbot (developer) 2009-11-11 19:23 |
Repository: erp/devel/pi Changeset: 9be52538e37fed0a8ee84d831f769c94fa0ccf32 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Wed Nov 11 19:22:31 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/9be52538e37fed0a8ee84d831f769c94fa0ccf32 [^] Fixed 11055: optimize 'Reading functions...' on postgres, now about 30s faster --- M src-db/database/lib/dbsourcemanager.jar --- |
|
(0021955) marvintm (developer) 2009-11-18 11:12 |
The changes are correct, and the export.database is definitely much faster. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-10-20 17:32 | shuehner | New Issue | |
| 2009-10-20 17:32 | shuehner | Assigned To | => marvintm |
| 2009-10-20 17:32 | shuehner | Note Added: 0021223 | |
| 2009-10-20 17:32 | shuehner | Issue Monitored: shuehner | |
| 2009-11-11 18:45 | shuehner | Note Added: 0021735 | |
| 2009-11-11 18:46 | shuehner | Assigned To | marvintm => shuehner |
| 2009-11-11 19:23 | hgbot | Checkin | |
| 2009-11-11 19:23 | hgbot | Note Added: 0021736 | |
| 2009-11-11 19:23 | hgbot | Status | new => resolved |
| 2009-11-11 19:23 | hgbot | Resolution | open => fixed |
| 2009-11-11 19:23 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/9be52538e37fed0a8ee84d831f769c94fa0ccf32 [^] |
| 2009-11-18 11:12 | marvintm | Note Added: 0021955 | |
| 2009-11-18 11:12 | marvintm | Status | resolved => closed |
| 2009-11-19 00:00 | anonymous | sf_bug_id | 0 => 2900149 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |