Hi,
(I'm working with Damien, alias DaffyDuck)
I made some complementary tests.
Withe a simple ejb using a datasource on both JBoss 3.0.6 and 3.2.5, I found the
following results (average time executing the same request 25 times)
jboss 3.0.6 ~70 ms
jboss 3.2.5 ~ 1000 ms !!!
I added some debug to my code and here are my results:
Executed CODE ms
JBOSS 3.0.6
BEGIN - PreparedStatement
END - PreparedStatement 0
BEGIN - executeQuery
END - executeQuery 0,031
BEGIN - WHILE (loop on resultset)
END - WHILE 0,037
BEGIN - RESULTSET.CLOSE
END - RESULTSET.CLOSE 0
BEGIN - PREPSTMT.CLOSE
END - PREPSTMT.CLOSE 0,001
BEGIN - RS.CLOSE
END - RS.CLOSE 0
JBOSS 3.2.5
BEGIN - PreparedStatement
END - PreparedStatement 0
BEGIN - executeQuery
END - executeQuery 0,307
BEGIN - WHILE (loop on resultset)
END - WHILE 0,722
BEGIN - RESULTSET.CLOSE
END - RESULTSET.CLOSE 0,033
BEGIN - PREPSTMT.CLOSE
END - PREPSTMT.CLOSE 0
BEGIN - RS.CLOSE
END - RS.CLOSE 0
As you can see, it's the executeQuery execution time that is x10 and the loop on the
resultset (rs.next()) execution time that is x20.
Additional information: we do have the same kind of results with a different driver
(jtds instead of M$).
Any sugestion or track to continue our investigations.
Br,
Marc.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845601#3845601
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845601
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
