3 Replies Latest reply on Mar 16, 2004 8:21 AM by Sven Baumgarten

    slow connection from conection cache

    Sven Baumgarten Newbie


      I have a cmp session bean that does direct sql request on the database. I take a connection from the servers connection cache and run a SELECT statement that returns a ResultSet of 200000 primary keys of a table. I cache the results in an int[] array. The hole task takes 11 seconds (1 sec for the SELECT and 10 for iteration the Resultset). If I do the same on a connection created by DriverManager.getConnection it takes only 700 millisec.

      I use JBoss 3.2.3 and SQL Server 2000.

      Why is iterating the ResultSet so slow on the connection from connection cache?

      regards, Sven