Hi, 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 <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825693#3825693";>View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825693>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
