Hi

In our project we have more than 50 types of SUGGESTION and each suggestion can have a BOOKLET (all the booklets have same data).

We have a Booklet class (and a Booklet table) with a one-to-one relation to an abstract Suggestion classes; and the Suggestion class has more than 50 joined-subclasses (properties of suggestions vary too much - each have at least 10 distinct properties which are not in share, and about 10 properties in share).

Our problem is when fetching a Suggestion with its id (primary key), a query joining more than 50 tables executes, the query is so slow, and takes more than 15 seconds to respond!

Although joined-subclasses don't support discriminator values, but we have a field in our Suggestion class with the same behaviour (it is the Suggestion's type field).

Is there any way to use discriminators in joined-subclasses so we can improve the performance (executing two simple queries is more perform than a query joining more thatn 50 tables!)

Hibernate version: 3.0

Name and version of the database you are using: Oracle 10g

sorry!! too many!