-->
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: Cross tables query
PostPosted: Wed Mar 30, 2005 8:44 am 
Newbie

Joined: Sun Aug 29, 2004 11:45 am
Posts: 16
I have two persistent entities mapped to two different tables. In my objectial model I do not hold any connection between then (one to one or many to one or many to many).
I have a simple query that retrieves records from one of the tables but with implicit join between the two tables, for example:

select entity from tests.Entity as entity ,tests.Second as second where entity.code=second.code

When I run this query in native SQL with a standarsd oracel client I get results in 0.4 seconds. When I run this query with hibernate I get the same results in 3 seconds.

What is the reason for this kind of diffrentiality?

P.S. I run tests like this more then once for other cases as complex as the above and for more complex cases and I always get a huge difference in performance.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Mar 30, 2005 12:49 pm 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
you dont show how you are doing this....please show code/mappings

_________________
Max
Don't forget to rate


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.