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 administrate this cache.
Hi, I am not an expert in CMP (so maybe you want to redirect your question there). But option A is read only, so I'd think once you retrieve the data, subsquent read should be really fast. As a result, I don't see why it is a problem.