1 Reply Latest reply on Mar 21, 2002 2:10 PM by Dain Sundstrom

    JBoss slow queries

    Tom Döhler Newbie

      Hi all,

      I have a question about JBoss performance in querying a database. I have an simple demo application deployed in jboss. There is a simple stateless session bean, that queries a sybase database server and returns an arraylist of primery key - objects.
      This arraylist is taken by another stateless session bean, that instantiates entity beans from the arraylist's primerykey - objects. This session bean generates an xml DOM and returns it to a jsp, which transforms it into html.

      The Problem is, that querying 25 primarykey - objects into the arraylist takes a average time of 10 seconds. That slows my webapplication down.

      Could this be a transaction problem ?