Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005787 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] I. Performance | major | always | 2008-11-01 16:12 | 2009-04-21 11:07 | |||
| Reporter | opablo | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 11261 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | 1.5 | |||
| OS Version | Database version | 10g | Ant version | 1.7 | ||||
| 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 | 0005787: Accounting | |||||||
| Description | The accounting process takes almost one second. This is fast enough for a few documents, but becomes a problem when many documents have to be processed. | |||||||
| Steps To Reproduce | Financial Management -> Accounting -> Transactions -> GL Posting by DB Tables | |||||||
| Tags | Performance, performance2.40scrum | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0010457) galderromo (reporter) 2008-11-20 17:06 |
Just to give some more information about target scenario. 600.000 sales invoices with 3 lines per invoice. 1.000 purchase invoices with 10 lines per invoice. 40 bank statements with 20.000 lines per bank statement (plus a settlement per bank statment) 5 cashes with 1.000 cash lines per cash. 15 manual settlements with 1.000 debt payments per settlement. 6.000 manual accounting entrances lines. This is a scenario occurs 12 times per year. A night is more or less 8 hours. Take into account other sincronization, invoicing, backup, etc. tasks are also scheduled every night. Anyway, this scenario is taking into account everyday activity. If issue 5979 is not attended, this scenario would be much worst. All the activity of a year should be accounted within 8 hours. |
|
(0011439) svnbot (reporter) 2008-12-16 17:48 |
Repository: openbravo Revision: 11261 Author: huehner Date: 2008-12-16 17:48:24 +0100 (Tue, 16 Dec 2008) Fixed 5787 Add missing index to speed up the accounting process. --- U trunk/src-db/database/model/tables/C_INVOICETAX.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=11261&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-11-01 16:12 | opablo | New Issue | |
| 2008-11-01 16:12 | opablo | Assigned To | => cromero |
| 2008-11-01 16:12 | opablo | sf_bug_id | 0 => 2214109 |
| 2008-11-01 16:12 | opablo | Issue Monitored: opablo | |
| 2008-11-03 10:11 | rafaroda | Tag Attached: Performance | |
| 2008-11-03 10:12 | rafaroda | Status | new => scheduled |
| 2008-11-03 10:12 | rafaroda | Assigned To | cromero => shuehner |
| 2008-11-03 10:12 | rafaroda | fix_in_branch | => trunk |
| 2008-11-05 12:23 | galderromo | Issue Monitored: galderromo | |
| 2008-11-20 17:06 | galderromo | Note Added: 0010457 | |
| 2008-11-20 17:12 | shuehner | Relationship added | related to 0005979 |
| 2008-11-30 17:27 | pjuvara | Tag Attached: performance2.40scrum | |
| 2008-12-03 19:03 | pjuvara | Priority | normal => high |
| 2008-12-16 17:48 | svnbot | Checkin | |
| 2008-12-16 17:48 | svnbot | Note Added: 0011439 | |
| 2008-12-16 17:48 | svnbot | Status | scheduled => resolved |
| 2008-12-16 17:48 | svnbot | Resolution | open => fixed |
| 2008-12-16 17:48 | svnbot | svn_revision | => 11261 |
| 2009-04-21 11:07 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |