You might have concurrent transactions that are writing into your table (like modifying the records) which will block the SELECT query until they're done. If the other transaction is waiting for something external before it commits, your select will take long.
Georges View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4126111#4126111 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4126111 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
