Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005787Openbravo ERPI. Performancepublic2008-11-01 16:122009-04-21 11:07
Reporteropablo 
Assigned Toshuehner 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005787: Accounting
DescriptionThe 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 ReproduceFinancial Management -> Accounting -> Transactions -> GL Posting by DB Tables
Proposed Solution
Additional Information
TagsPerformance, performance2.40scrum
Relationships
related to feature request 0005979 closed  Parametrize accounting processes (Generate and Delete Accountin) by date 
depends on backport 0005791 closed shuehner Accounting 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-01 16:12opabloNew Issue
2008-11-01 16:12opabloAssigned To => cromero
2008-11-01 16:12opablosf_bug_id0 => 2214109
2008-11-01 16:12opabloIssue Monitored: opablo
2008-11-03 10:11rafarodaTag Attached: Performance
2008-11-03 10:12rafarodaStatusnew => scheduled
2008-11-03 10:12rafarodaAssigned Tocromero => shuehner
2008-11-03 10:12rafarodafix_in_branch => trunk
2008-11-05 12:23galderromoIssue Monitored: galderromo
2008-11-20 17:06galderromoNote Added: 0010457
2008-11-20 17:12shuehnerRelationship addedrelated to 0005979
2008-11-30 17:27pjuvaraTag Attached: performance2.40scrum
2008-12-03 19:03pjuvaraPrioritynormal => high
2008-12-16 17:48svnbotCheckin
2008-12-16 17:48svnbotNote Added: 0011439
2008-12-16 17:48svnbotStatusscheduled => resolved
2008-12-16 17:48svnbotResolutionopen => fixed
2008-12-16 17:48svnbotsvn_revision => 11261
2009-04-21 11:07psarobeStatusresolved => closed

Notes
(0010457)
galderromo   
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   
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 [^]