David Blevins <david.blevins <at> gmail.com> writes:
I have noticed the same issue on my project. The EJB 2.x.
Exactly the same behavior as described on the top
First response is very quickly and then it becomes worse and aprox after 500
requests it performance becomes slower twice
First investigations shows the entity bean findAll query method is the
issue.
Here is the ejb-jar conf for this method:
<entity id="BreakReason">
<ejb-name>BreakReason</ejb-name>
<local-home>com.trizetto.workflow.ejb.BreakReasonLocalHome</local-
home>
<local>com.trizetto.workflow.ejb.BreakReasonLocal</local>
<ejb-class>com.trizetto.workflow.ejb.BreakReasonBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>com.trizetto.workflow.ejb.BreakReasonKey</prim-key-
class>
<reentrant>false</reentrant>
<cmp-version>2.x</cmp-version>
<abstract-schema-name>BreakReason</abstract-schema-name>
<cmp-field id="CMPAttribute_1061568652677">
<field-name>reasonID</field-name>
</cmp-field>
<cmp-field id="CMPAttribute_1061568657153">
<field-name>reasonDesc</field-name>
</cmp-field>
<cmp-field id="CMPAttribute_1241725251750">
<field-name>reasonType</field-name>
</cmp-field>
<query>
<description></description>
<query-method>
<method-name>findAll</method-name>
<method-params></method-params>
</query-method>
<ejb-ql>select object(o) from BreakReason o order by
o.reasonDesc</ejb-ql>
</query>
