Slow response on search using EJB

mgarcia3s Jul 7, 2004 4:55 AM

Hi all,

I have an J2EE application with the next configuration:
JBoss 3.2.4 - Oracle

The oracle driver used in JBoss is "jbosscmp-jdbc3.0". Related with
JBoss configuration we have the next settings:

Commit option type "A": Only JBoss can modify the DB
Methods get are in "read only" status

With this configuration the response after a query is 1 sec/row
As you can see this is a lot, because I´ve about 200 rows, so It´s
taking a lot of time. Could you please say to me how can I improve
the performance?

(I have installed also JBoss cache but I don´t know exactly how to
manage this one)

Best regards

1. Re: Slow response on search using EJB

triathlon98 Jul 7, 2004 7:16 AM (in response to mgarcia3s)

Try not using the "read only" status. There have been discussions that this does more bad than good in recent versions.

If that does not work, enable debug logging so you can see the executed SQL statements.

Joachim
Actions