Re: [Hibernate] Performance Problem - lots of many-to-one associa tions

[Gavin King]

0.3 seconds is an awfully long time for loading _one_row_!

Joseph Toth wrote:

Ahha, outer-join="false" was the key ...
Now it only takes 0.3 seconds to load that object! Thank you so much! 

 

-----Original Message-----
From: Gavin King [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 2:32 PM
To: Joseph Toth
Cc: '[EMAIL PROTECTED]'
Subject: Re: [Hibernate] Performance Problem - lots of many-to-one
associations


   

All the foreign tables should be cached indefinately.  There 
     

are only a
   

couple rows in each.
Is a way for hibernate to, when loading PanelDemographics, 
     

the sql generated
   

would just select the id's of the foreign tables, then grab 
     

the objects from
   

the cache.

     

Absolutely. Enable JCS on the associated classes, and set 
outer-join="false" on the association.



   



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel