Hi!

I've got a question concerning a command that seems to take a lot of time. I enabled trace, because I was searching for a reasons of slow performance of my application (BMP EJB, some stateful session beans, JSP Frontend using Tomcat).
Why does the command marked with !!! in the following log take over 800 ms to complete? And what options do I have to improve performance?

I am using the standard BMP Instance per Transaction configuration with commit option B, because their is another application modifiying the database.



[...]
2004-06-08 15:59:59,295 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start method=findByTermin
2004-06-08 15:59:59,305 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is TransactionImpl:XidImpl [FormatId=257, GlobalId=schellepp//23, BranchQual=]
2004-06-08 15:59:59,305 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_REQUIRED for findByTermin
2004-06-08 15:59:59,305 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx TransactionImpl:XidImpl [FormatId=257, GlobalId=schellepp//23, BranchQual=]
!!! 2004-06-08 15:59:59,305 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get instance org.jboss.ejb.plugins.EntityInstancePool@85e57#0#class r7.ejb.AuftraegeEJB
!!! 2004-06-08 16:00:00,146 TRACE [org.jboss.ejb.plugins.EntityInstancePool] 0/100 Free instance:org.jboss.ejb.plugins.EntityInstancePool@85e57#null#null#false#class r7.ejb.AuftraegeEJB
2004-06-08 16:00:00,146 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TxInterceptorCMT: In finally
[...]


I am pretty new to JBoss and hope that somebody can give me a hint what to try next.

Regards,

Sven Beermann