Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0023880Openbravo ERP09. Financial managementpublic2013-05-22 11:342015-02-25 18:20
shuehner 
eduardo_Argal 
normalmajorhave not tried
feedbackopen 
5
 
 
Core
No
0023880: FIN_AddPayment.calculateOverdueAmount is very slow
That function is very slow taking up to 600ms to process a single entry.

Analyzing this slowdown shows a very high dal overhead calling the small pl-function APRM_ISPAYMENTCONFIRMED.

As that function is supposd to be stable (returning same output when giving same input several times) adding a java hashmap as a java based cache does improve runtime greatly.

Observed runtime improvement in one customer is from 5min30sec downto 20-25seconds.

I.e. using the remittance module
Use the settle/protest window
and settle many entries at once.
See description and attached prototype patch

NOTE: that patch introduced a behavior/api-change which has to be discussed /decided upon before implementing this change.
No tags attached.
diff ispaymentconfirmed_cache.diff (1,614) 2013-05-22 11:35
https://issues.openbravo.com/file_download.php?file_id=6153&type=bug
Issue History
2013-05-22 11:34shuehnerNew Issue
2013-05-22 11:34shuehnerAssigned To => dmiguelez
2013-05-22 11:34shuehnerModules => Core
2013-05-22 11:34shuehnerTriggers an Emergency Pack => No
2013-05-22 11:35shuehnerFile Added: ispaymentconfirmed_cache.diff
2014-09-03 14:10eduardo_ArgalAssigned Todmiguelez => eduardo_Argal
2015-02-25 18:20eduardo_ArgalNote Added: 0074921
2015-02-25 18:20eduardo_ArgalStatusnew => feedback

Notes
(0074921)
eduardo_Argal   
2015-02-25 18:20   
Any idea is this is old? It seems the original code is not there