[
https://issues.apache.org/jira/browse/OFBIZ-13166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17895096#comment-17895096
]
Jacques Le Roux edited comment on OFBIZ-13166 at 11/3/24 7:57 AM:
------------------------------------------------------------------
If we excerpt the reported costs of services, we get this:
{noformat}
Rechercher "milliseconds" (52 résultats dans 1 documents depuis 1 documents
recherchés) [Normal]
nouveau 1 (52 résultats)
Ligne 33: 2024-11-02 19:07:00,781 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getUserPreference] finished in [2]
milliseconds
Ligne 34: 2024-11-02 19:07:00,783 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getUserPreference] finished in [1]
milliseconds
Ligne 36: 2024-11-02 19:07:00,807 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getUserPreferenceGroup] finished in
[1] milliseconds
Ligne 40: 2024-11-02 19:07:01,069 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/genericBasePermissionCheck] finished
in [106] milliseconds
Ligne 42: 2024-11-02 19:07:01,090 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/acctgBasePermissionCheck] finished in
[261] milliseconds
Ligne 46: 2024-11-02 19:07:01,490 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getLastSystemInfoNote] finished in
[46] milliseconds
Ligne 50: 2024-11-02 19:07:05,093
|jsse-nio-8443-exec-2 |ServiceDispatcher |T| Sync service
[accounting/getInvoicePaymentInfoList] finished in [2092] milliseconds
Ligne 51: 2024-11-02 19:07:05,101 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 52: 2024-11-02 19:07:05,108 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 53: 2024-11-02 19:07:05,113 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[3] milliseconds
Ligne 56: 2024-11-02 19:07:05,120 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/genericBasePermissionCheck] finished
in [3] milliseconds
Ligne 57: 2024-11-02 19:07:05,121 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/acctgPrefPermissionCheck] finished in
[6] milliseconds
Ligne 58: 2024-11-02 19:07:05,336 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyAccountingPreferences]
finished in [222] milliseconds
Ligne 59: 2024-11-02 19:07:05,435
|jsse-nio-8443-exec-2 |ServiceDispatcher |T| Sync service
[accounting/getInvoiceRunningTotal] finished in [3470] milliseconds
Ligne 60: 2024-11-02 19:07:06,709
|jsse-nio-8443-exec-2 |ServiceDispatcher |T| Sync service
[accounting/getPartyNameForDate] finished in [1184] milliseconds
Ligne 65: 2024-11-02 19:07:07,028 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [3]
milliseconds
Ligne 66: 2024-11-02 19:07:07,050 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [4]
milliseconds
Ligne 67: 2024-11-02 19:07:07,075 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [4]
milliseconds
Ligne 68: 2024-11-02 19:07:07,111 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 69: 2024-11-02 19:07:07,118 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 70: 2024-11-02 19:07:07,125 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[6] milliseconds
Ligne 71: 2024-11-02 19:07:07,134 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[7] milliseconds
Ligne 74: 2024-11-02 19:07:07,138 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/genericBasePermissionCheck] finished
in [2] milliseconds
Ligne 75: 2024-11-02 19:07:07,140 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/acctgPrefPermissionCheck] finished in
[4] milliseconds
Ligne 76: 2024-11-02 19:07:07,144 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyAccountingPreferences]
finished in [9] milliseconds
Ligne 77: 2024-11-02 19:07:07,145 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoiceRunningTotal] finished in
[41] milliseconds
Ligne 78: 2024-11-02 19:07:07,182 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[6] milliseconds
Ligne 79: 2024-11-02 19:07:07,186 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[3] milliseconds
Ligne 80: 2024-11-02 19:07:07,191 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[3] milliseconds
Ligne 81: 2024-11-02 19:07:07,197 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 82: 2024-11-02 19:07:07,203 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[4] milliseconds
Ligne 83: 2024-11-02 19:07:07,208 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[4] milliseconds
Ligne 86: 2024-11-02 19:07:07,212 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/genericBasePermissionCheck] finished
in [2] milliseconds
Ligne 87: 2024-11-02 19:07:07,214 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/acctgPrefPermissionCheck] finished in
[4] milliseconds
Ligne 88: 2024-11-02 19:07:07,219 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyAccountingPreferences]
finished in [9] milliseconds
Ligne 89: 2024-11-02 19:07:07,220 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoiceRunningTotal] finished in
[44] milliseconds
Ligne 90: 2024-11-02 19:07:07,249 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [4]
milliseconds
Ligne 91: 2024-11-02 19:07:07,272 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [3]
milliseconds
Ligne 92: 2024-11-02 19:07:07,292 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [4]
milliseconds
Ligne 93: 2024-11-02 19:07:07,307 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [3]
milliseconds
Ligne 94: 2024-11-02 19:07:07,319 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [2]
milliseconds
Ligne 95: 2024-11-02 19:07:07,331 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [3]
milliseconds
Ligne 96: 2024-11-02 19:07:07,353 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[3] milliseconds
Ligne 97: 2024-11-02 19:07:07,365 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[9] milliseconds
Ligne 98: 2024-11-02 19:07:07,371 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[4] milliseconds
Ligne 99: 2024-11-02 19:07:07,377 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 100: 2024-11-02 19:07:07,382 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[4] milliseconds
Ligne 101: 2024-11-02 19:07:07,386 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[3] milliseconds
Ligne 104: 2024-11-02 19:07:07,389 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/genericBasePermissionCheck] finished
in [1] milliseconds
Ligne 105: 2024-11-02 19:07:07,390 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/acctgPrefPermissionCheck] finished in
[3] milliseconds
Ligne 106: 2024-11-02 19:07:07,394 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyAccountingPreferences]
finished in [7] milliseconds
Ligne 107: 2024-11-02 19:07:07,395 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoiceRunningTotal] finished in
[47] milliseconds
2024-11-02 19:07:07,421 |jsse-nio-8443-exec-2
|ControlServlet |T| [[[accounting::main
(Domain:https://localhost)] Request Done- total:7.052,since
last([accounting::main...):7.052]]
{noformat}
So the total cost is ~7 sec.
With
getInvoicePaymentInfoList] finished in [2092] milliseconds
getInvoiceRunningTotal] finished in [3470] milliseconds
getPartyNameForDate] finished in [1184] milliseconds
These services cost ~ 2 + 3.5 + 1 = 6.5 sec.
Remains only .5 sec. Clearly loading InvoiceReport.groovy 4 times is not the
reason. As most often querying the DB is the higher cost.
was (Author: jacques.le.roux):
If we excerpt the reported costs of services, we get this:
{noformat}
Rechercher "milliseconds" (52 résultats dans 1 documents depuis 1 documents
recherchés) [Normal]
nouveau 1 (52 résultats)
Ligne 33: 2024-11-02 19:07:00,781 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getUserPreference] finished in [2]
milliseconds
Ligne 34: 2024-11-02 19:07:00,783 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getUserPreference] finished in [1]
milliseconds
Ligne 36: 2024-11-02 19:07:00,807 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getUserPreferenceGroup] finished in
[1] milliseconds
Ligne 40: 2024-11-02 19:07:01,069 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/genericBasePermissionCheck] finished
in [106] milliseconds
Ligne 42: 2024-11-02 19:07:01,090 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/acctgBasePermissionCheck] finished in
[261] milliseconds
Ligne 46: 2024-11-02 19:07:01,490 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getLastSystemInfoNote] finished in
[46] milliseconds
Ligne 50: 2024-11-02 19:07:05,093
|jsse-nio-8443-exec-2 |ServiceDispatcher |T| Sync service
[accounting/getInvoicePaymentInfoList] finished in [2092] milliseconds
Ligne 51: 2024-11-02 19:07:05,101 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 52: 2024-11-02 19:07:05,108 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 53: 2024-11-02 19:07:05,113 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[3] milliseconds
Ligne 56: 2024-11-02 19:07:05,120 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/genericBasePermissionCheck] finished
in [3] milliseconds
Ligne 57: 2024-11-02 19:07:05,121 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/acctgPrefPermissionCheck] finished in
[6] milliseconds
Ligne 58: 2024-11-02 19:07:05,336 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyAccountingPreferences]
finished in [222] milliseconds
Ligne 59: 2024-11-02 19:07:05,435
|jsse-nio-8443-exec-2 |ServiceDispatcher |T| Sync service
[accounting/getInvoiceRunningTotal] finished in [3470] milliseconds
Ligne 60: 2024-11-02 19:07:06,709
|jsse-nio-8443-exec-2 |ServiceDispatcher |T| Sync service
[accounting/getPartyNameForDate] finished in [1184] milliseconds
Ligne 65: 2024-11-02 19:07:07,028 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [3]
milliseconds
Ligne 66: 2024-11-02 19:07:07,050 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [4]
milliseconds
Ligne 67: 2024-11-02 19:07:07,075 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [4]
milliseconds
Ligne 68: 2024-11-02 19:07:07,111 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 69: 2024-11-02 19:07:07,118 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 70: 2024-11-02 19:07:07,125 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[6] milliseconds
Ligne 71: 2024-11-02 19:07:07,134 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[7] milliseconds
Ligne 74: 2024-11-02 19:07:07,138 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/genericBasePermissionCheck] finished
in [2] milliseconds
Ligne 75: 2024-11-02 19:07:07,140 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/acctgPrefPermissionCheck] finished in
[4] milliseconds
Ligne 76: 2024-11-02 19:07:07,144 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyAccountingPreferences]
finished in [9] milliseconds
Ligne 77: 2024-11-02 19:07:07,145 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoiceRunningTotal] finished in
[41] milliseconds
Ligne 78: 2024-11-02 19:07:07,182 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[6] milliseconds
Ligne 79: 2024-11-02 19:07:07,186 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[3] milliseconds
Ligne 80: 2024-11-02 19:07:07,191 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[3] milliseconds
Ligne 81: 2024-11-02 19:07:07,197 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 82: 2024-11-02 19:07:07,203 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[4] milliseconds
Ligne 83: 2024-11-02 19:07:07,208 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[4] milliseconds
Ligne 86: 2024-11-02 19:07:07,212 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/genericBasePermissionCheck] finished
in [2] milliseconds
Ligne 87: 2024-11-02 19:07:07,214 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/acctgPrefPermissionCheck] finished in
[4] milliseconds
Ligne 88: 2024-11-02 19:07:07,219 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyAccountingPreferences]
finished in [9] milliseconds
Ligne 89: 2024-11-02 19:07:07,220 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoiceRunningTotal] finished in
[44] milliseconds
Ligne 90: 2024-11-02 19:07:07,249 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [4]
milliseconds
Ligne 91: 2024-11-02 19:07:07,272 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [3]
milliseconds
Ligne 92: 2024-11-02 19:07:07,292 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [4]
milliseconds
Ligne 93: 2024-11-02 19:07:07,307 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [3]
milliseconds
Ligne 94: 2024-11-02 19:07:07,319 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [2]
milliseconds
Ligne 95: 2024-11-02 19:07:07,331 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyNameForDate] finished in [3]
milliseconds
Ligne 96: 2024-11-02 19:07:07,353 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[3] milliseconds
Ligne 97: 2024-11-02 19:07:07,365 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[9] milliseconds
Ligne 98: 2024-11-02 19:07:07,371 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[4] milliseconds
Ligne 99: 2024-11-02 19:07:07,377 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[5] milliseconds
Ligne 100: 2024-11-02 19:07:07,382 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[4] milliseconds
Ligne 101: 2024-11-02 19:07:07,386 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoicePaymentInfoList] finished in
[3] milliseconds
Ligne 104: 2024-11-02 19:07:07,389 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/genericBasePermissionCheck] finished
in [1] milliseconds
Ligne 105: 2024-11-02 19:07:07,390 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/acctgPrefPermissionCheck] finished in
[3] milliseconds
Ligne 106: 2024-11-02 19:07:07,394 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getPartyAccountingPreferences]
finished in [7] milliseconds
Ligne 107: 2024-11-02 19:07:07,395 |jsse-nio-8443-exec-2 |ServiceDispatcher
|T| Sync service [accounting/getInvoiceRunningTotal] finished in
[47] milliseconds
2024-11-02 19:07:07,421 |jsse-nio-8443-exec-2
|ControlServlet |T| [[[accounting::main
(Domain:https://localhost)] Request Done- total:7.052,since
last([accounting::main...):7.052]]
{noformat}
So the total cost is ~7 sec.
With
getInvoicePaymentInfoList] finished in [2092] milliseconds
getInvoiceRunningTotal] finished in [3470] milliseconds
getPartyNameForDate] finished in [1184] milliseconds
These services cost ~ 2 + 3.5 + 1 = 6.5 sec. Remains only .5 sec.
> Accounting main screen is little slow because of loading groovy script 4
> times.
> -------------------------------------------------------------------------------
>
> Key: OFBIZ-13166
> URL: https://issues.apache.org/jira/browse/OFBIZ-13166
> Project: OFBiz
> Issue Type: Improvement
> Components: accounting
> Reporter: Jacques Le Roux
> Assignee: Jacques Le Roux
> Priority: Trivial
>
> At https://lists.apache.org/thread/jlf21nd7znkl76v5t99xhyp2qz13j6tz
> [~abuomar] reported this issue
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
