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

2003-09-16 Thread Juozas Baliuka
I am not sure it can help for you, but sometimes I use this for "readonly" data : transform tables like "TBL_CITY" or "TBL_COUNTRY" to "properties" file and store this data on client side. > Using Hibernate 2.0.3 > > We have a table "panel_demographics" (xml at bottom) which holds foreign > ke

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

2003-09-16 Thread Gavin King
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

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

2003-09-16 Thread Joseph Toth
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) ses