-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: Problems in mapping two many joined-subclasses
PostPosted: Sat Nov 26, 2005 6:01 am 
Senior
Senior

Joined: Sat Nov 27, 2004 4:13 am
Posts: 137
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

_________________
don't forget to credit!

Amir Pashazadeh
Payeshgaran MT
پايشگران مديريت طرح
http://www.payeshgaran.co
http://www.payeshgaran.org
http://www.payeshgaran.net


Top
 Profile  
 
 Post subject: oops! too many!
PostPosted: Sat Nov 26, 2005 6:04 am 
Senior
Senior

Joined: Sat Nov 27, 2004 4:13 am
Posts: 137
sorry!! too many!

_________________
don't forget to credit!

Amir Pashazadeh
Payeshgaran MT
پايشگران مديريت طرح
http://www.payeshgaran.co
http://www.payeshgaran.org
http://www.payeshgaran.net


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.