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

Hello, I try to debug my seam application, using hibernate 3.2.4. I have a oddly long request: | 06:05:36,267 INFO [STDOUT] Collaborateur - getRegies : Feb 2, 2008 6:05:36 AM | 06:05:36,267 INFO [STDOUT] Collaborateur - getOD : Feb 2, 2008 6:05:36 AM | 06:05:36,268 INFO [STDOUT] Collaborateur - getRegies : Feb 2, 2008 6:05:36 AM | 06:05:36,268 INFO [STDOUT] Collaborateur - getOD : Feb 2, 2008 6:05:36 AM | 06:05:36,853 INFO [STDOUT] Hibernate: select societe0_.societe_id as societe1_40_, societe0_.taux_tva as taux4_40_, societe0_.logo_societe as logo2_40_, societe0_.code_societe as code3_40_, societe0_.condition_reglement as condition5_40_ from societe societe0_ limit ? | 06:05:53,628 INFO [STDOUT] Collaborateur - getRegies : Feb 2, 2008 6:05:53 AM | 06:05:53,713 INFO [STDOUT] Collaborateur - getRegies : Feb 2, 2008 6:05:53 AM | As you can see on the debug, the "select societe" took 17 seconds but there is only 2 lines in my "societe" table. A lot of relations exists to this table but everything is in lazy so I'm sure I'm pretty sure I'm not fetching the whole database here ... Does anybody have an idea on that problem ? Regards View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4125736#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...