[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Anormally long time for a query

[georgesberscheid]

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