Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005791Openbravo ERPI. Performancepublic2008-11-03 10:122009-05-21 16:37
Reporteropablo 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005791: 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
TagsNo tags attached.
Relationships
related to defect 0006589 closed anthony_wolski When background accounting is disabled and you use posting by db tables, after the process background accounting will be running 
blocks defect 0005787 closed shuehner Accounting 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-03 10:12rafarodaNew Issue
2008-11-03 10:12rafarodaAssigned To => shuehner
2008-11-03 10:12rafarodaStatusnew => scheduled
2008-12-16 16:37svnbotCheckin
2008-12-16 16:37svnbotNote Added: 0011422
2008-12-16 16:37svnbotsvn_revision => 11253
2008-12-16 16:42svnbotCheckin
2008-12-16 16:42svnbotNote Added: 0011424
2008-12-16 16:42svnbotStatusscheduled => resolved
2008-12-16 16:42svnbotResolutionopen => fixed
2008-12-16 16:42svnbotsvn_revision11253 => 11254
2008-12-16 16:57shuehnerRelationship addedrelated to 0006589
2008-12-16 17:50shuehnerNote Added: 0011440
2008-12-26 13:24galderromoIssue Monitored: galderromo
2009-05-21 16:37psarobeStatusresolved => closed

Notes
(0011422)
svnbot   
2008-12-16 16:37   
Repository: openbravo
Revision: 11253
Author: huehner
Date: 2008-12-16 16:37:15 +0100 (Tue, 16 Dec 2008)

Issue 5791
- Change behavior of the accounting process when launched via Posting by DB tables (not the background process)
  In this case now all available documents are processed without 10s sleep-time every 50 documents, to achieve
  a much greater throughput.
Issue 5979
- Prepare the accounting process for a new parameter to filter by fromDate and toDate.
  Just preparation here, not a complete implementation

---
U branches/r2.40performance/src/org/openbravo/erpCommon/ad_background/PeriodicAcctServer.java
U branches/r2.40performance/src/org/openbravo/erpCommon/ad_forms/AcctServer.java
U branches/r2.40performance/src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11253&sc=1 [^]
(0011424)
svnbot   
2008-12-16 16:42   
Repository: openbravo
Revision: 11254
Author: huehner
Date: 2008-12-16 16:42:13 +0100 (Tue, 16 Dec 2008)

Fixed 5791
Add missing index to speed up the accounting process.

---
U branches/r2.40performance/src-db/database/model/tables/C_INVOICETAX.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11254&sc=1 [^]
(0011440)
shuehner   
2008-12-16 17:50   
With the last two changes (don't wait 10s every 5documents when running from Posting from DB tables and the added index) the speed for accounting i.e. sales invoices with 3 lines each is around 16-25 documents per seconds (depending on then jit-compilation).