[Hibernate] Query Counter Interceptor?

Hi all, I am doing some performance tuning on my Hibernate based app. I noticed that a lot of my HQL is quite unoptimized, and requires many hits to the database. So I am using a combination of JunitPerf to monitor how long a unit test takes and the show_sql to look at the number of SQL statemen

[Hibernate] (no subject)

Hi everyone,     I have an object named EntiteAffaire that has a collection (many-to-many relation with a composite-element) of coordinate. A coordinate can be a telephone, an address or an email. In the coordinate table, there is a field named "KIND_COO" that tells me which kind of coordi

Re: [Hibernate] Query Counter Interceptor?

http://www.p6spy.com/ Try to query system views for statistics, it must help for performance tuning too. - Original Message - From: "Eric Pugh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 24, 2003 11:30 AM Subject: [Hibernate] Query Counter Interceptor? > Hi all,

[Hibernate] Design question: am I asking for trouble?

A quick design question whether I'm asking for trouble I have a class with self-referential sets. Call it: class Person { // @hibernate.identifier private Long id; // @hibernate.set table="parents" // key=child_id value=parent_id cascade="all" private Set parents; /

[Hibernate] Filtering collections with where clause??

Title: Message Hi everyone,     I have an object named EntiteAffaire that has a collection (many-to-many relation with a composite-element) of coordinate. A coordinate can be a telephone, an address or an email. In the coordinate table, there is a field named "KIND_COO" that tells me wh

Re: [Hibernate] Filtering collections with where clause??

Have you tried the where attribute of the element? St-Pierre Philip wrote: Hi everyone, I have an object named EntiteAffaire that has a collection (many-to-many relation with a composite-element) of coordinate. A coordinate can be a telephone, an address or an email. In the coordinate

RE: [Hibernate] Design question: am I asking for trouble?

I have found that self-referential entities work just fine. Just make sure that you lazily load everything so that hibernate doesn't have to load your entire object graph into memory with every call. If you have a single parent object with a getter/setter, you'll want to use proxies, but if your

Re: [Hibernate] Query Counter Interceptor?

Eric Pugh wrote: Hi all, I am doing some performance tuning on my Hibernate based app. I noticed that a lot of my HQL is quite unoptimized, and requires many hits to the database. So I am using a combination of JunitPerf to monitor how long a unit test takes and the show_sql to look at the numb