findBy usage

[Florin Popa]

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