Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005791
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] I. Performancemajoralways2008-11-03 10:122009-05-21 16:37
ReporteropabloView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branch2.40-performanceFixed in SCM revision11254
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version1.5
OS VersionDatabase version10gAnt version1.7
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005791: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0006589 closedanthony_wolski When background accounting is disabled and you use posting by db tables, after the process background accounting will be running 
blocks defect 0005787 closedshuehner Accounting 

-  Notes
(0011422)
svnbot (reporter)
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 (reporter)
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 (administrator)
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).

- Issue History
Date Modified Username Field Change
2008-11-03 10:12 rafaroda New Issue
2008-11-03 10:12 rafaroda Assigned To => shuehner
2008-11-03 10:12 rafaroda Status new => scheduled
2008-12-16 16:37 svnbot Checkin
2008-12-16 16:37 svnbot Note Added: 0011422
2008-12-16 16:37 svnbot svn_revision => 11253
2008-12-16 16:42 svnbot Checkin
2008-12-16 16:42 svnbot Note Added: 0011424
2008-12-16 16:42 svnbot Status scheduled => resolved
2008-12-16 16:42 svnbot Resolution open => fixed
2008-12-16 16:42 svnbot svn_revision 11253 => 11254
2008-12-16 16:57 shuehner Relationship added related to 0006589
2008-12-16 17:50 shuehner Note Added: 0011440
2008-12-26 13:24 galderromo Issue Monitored: galderromo
2009-05-21 16:37 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker