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

limousyf do-not-reply at jboss.com
Sat Feb 2 00:12:49 EST 2008


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#4125736

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4125736



More information about the jboss-user mailing list