[Hibernate] Performance Problem - lots of many-to-one associations

Using Hibernate 2.0.3 We have a table panel_demographics (xml at bottom) which holds foreign keys to many other tables. These other (metadata) tables all look basically the same, at the bottom Education is an example. A query like: PanelDemographics panelDemographics = (PanelDemographics)

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