1 Reply Latest reply on Jul 7, 2004 7:16 AM by Joachim Van der Auwera

    Slow response on search using EJB

    mgarcia3s Newbie

      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