Hello,
Within a special price calculation method, there are several
delegator.findByAnd or findByAndCache calls
In a very random way, the response time for 10 executions looks as below:
[java] !!!! END price calculation took:118
[java] !!!! END price calculation took:117
[java] !!!! END price calculation took:115
[java] !!!! END price calculation took:114
[java] !!!! END price calculation took:112
[java] !!!! END price calculation took:117
[java] !!!! END price calculation took:5951
[java] !!!! END price calculation took:116
[java] !!!! END price calculation took:113
[java] !!!! END price calculation took:112
[java] !!!! END price calculation took:113
[java] !!!! END price calculation took:116
[java] !!!! END price calculation took:114
[java] !!!! END price calculation took:115
[java] !!!! END price calculation took:114
[java] !!!! END price calculation took:7266
[java] !!!! END price calculation took:117
[java] !!!! END price calculation took:115
[java] !!!! END price calculation took:6463
[java] !!!! END price calculation took:6530
[java] !!!! END price calculation took:153
[java] !!!! END price calculation took:112
[java] !!!! END price calculation took:313
[java] !!!! END price calculation took:125
[java] !!!! END price calculation took:125
[java] !!!! END price calculation took:126
[java] !!!! END price calculation took:130
[java] !!!! END price calculation took:134
[java] !!!! END price calculation took:125
[java] !!!! END price calculation took:124
[java] !!!! END price calculation took:114
[java] !!!! END price calculation took:952
[java] !!!! END price calculation took:120
[java] !!!! END price calculation took:115
[java] !!!! END price calculation took:116
[java] !!!! END price calculation took:117
[java] !!!! END price calculation took:125
[java] !!!! END price calculation took:127
[java] !!!! END price calculation took:114
[java] !!!! END price calculation took:786
[java] !!!! END price calculation took:113
[java] !!!! END price calculation took:111
[java] !!!! END price calculation took:112
[java] !!!! END price calculation took:114
[java] !!!! END price calculation took:853
[java] !!!! END price calculation took:112
[java] !!!! END price calculation took:112
[java] !!!! END price calculation took:115
[java] !!!! END price calculation took:115
[java] !!!! END price calculation took:114
[java] !!!! END price calculation took:4636
[java] !!!! END price calculation took:119
[java] !!!! END price calculation took:117
[java] !!!! END price calculation took:112
[java] !!!! END price calculation took:117
[java] !!!! END price calculation took:113
[java] !!!! END price calculation took:115
[java] !!!! END price calculation took:113
[java] !!!! END price calculation took:572
[java] !!!! END price calculation took:117
[java] !!!! END price calculation took:113
[java] !!!! END price calculation took:1074
[java] !!!! END price calculation took:112
[java] !!!! END price calculation took:116
[java] !!!! END price calculation took:113
[java] !!!! END price calculation took:113
[java] !!!! END price calculation took:112
[java] !!!! END price calculation took:113
[java] !!!! END price calculation took:116
[java] !!!! END price calculation took:123
I mention there are proper indexes for all tables corresponding to all
"where clauses"
Could someone explain me why is most of the times slow or very slow?
Thanks,
Flopa
