Hibernate Community • View topic - Query optimization suggestion

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Query optimization suggestion

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

koda2

Post subject: Query optimization suggestion

Posted: Thu Feb 16, 2006 1:31 pm

Beginner

Joined: Wed Sep 28, 2005 5:30 pm
Posts: 25

Hi,

I ran some Hibernate code through a profiler and noticed that AbstractSessionImpl.getHQLQueryPlan() is invoked both from Session.createQuery() and Query.list(). In both cases, autoFlushIfNecessary() is invoked and this operation is rather expensive.

Why do you need to flush the session *both* at Query creation and at query invocation? Isn't it enough to only flush at invocation time?

Top

MikePloed

Post subject:

Posted: Thu Feb 16, 2006 1:33 pm

Expert

Joined: Tue Dec 07, 2004 6:57 am
Posts: 285
Location: Nürnberg, Germany

We even had a problem with this method during session.createQuery...

A comment from the hibernate team to this would be very helpful

http://forum.hibernate.org/viewtopic.php?t=955629

Top

koda2

Post subject: Re: Query optimization suggestion

Posted: Fri Feb 17, 2006 4:11 am

Beginner

Joined: Wed Sep 28, 2005 5:30 pm
Posts: 25

A few days go by and ... nothing?!

Guys, I would appreciate it if you at least let me know whether my idea holds water or not.

Top

koda2

Post subject:

Posted: Sat Feb 18, 2006 7:59 pm

Beginner

Joined: Wed Sep 28, 2005 5:30 pm
Posts: 25

Posted JIRA issue: http://opensource2.atlassian.com/projec ... e/HHH-1508

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

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