Can you post the code of your stored procedure?
40.000 records in 5-6 seconds is too low. I would expect much better performance.
Regards
Felix
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4039864#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...