Any cache to optimize? Prepared stmt activated on the pool? Anyway, thanks for the relevant feedback and for helping in the diagnose process.
JLouis 2014-04-04 11:46 GMT+02:00 ivan nikitsenka <[email protected]>: > 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> > > -- Jean-Louis
