Hibernate Community • View topic - Hibernate Java PersistantBag.size() Performance Problem

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Hibernate Java PersistantBag.size() Performance Problem

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

klemens1959

Post subject: Hibernate Java PersistantBag.size() Performance Problem

Posted: Fri Mar 27, 2009 7:37 am

Newbie

Joined: Thu Mar 26, 2009 2:32 pm
Posts: 3
Location: Germany

Hi,

Sorry, this message should be devoted to the hibernate forum! It's a Java based problem.

I am writting a Hibernate based application for the open source project www.opentms.de.

I encountered now the strange problem (at least to me) that when I run a query

Code:

query = session
                    .createQuery("select m from SQLMonoLingualObject s, SQLMonoLingualObject t, SQLMultiLingualObject m where s.parentMultiLingualObject = t.parentMultiLingualObject and s.language = '"
                            + sourceLanguage + "' and t.language = '" + targetLanguage + "' and  m.id = s.parentMultiLingualObject");

and then retrieving all the found objects the application nearly spends all the time in the method PersistantBag.size() as shown in the picture.

The model behind the data is simple:

A MUL (MultiLingualObject) has some string attributes, a list of TmxProps (bidirectional OneToMany) and MOLs (bidirectional OneToMany) associated with it. A MOL (MonoLingualObject) has some string attributes and a list of TmxProps (bidirectional OneToMany) associated with it.

Any idea what is the reason for this strange behaviour?

Thanks for help or explanations!

Klemens

Top

klemens1959

Post subject: Problem solved

Posted: Sat Mar 28, 2009 12:11 pm