openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From QkI <kukis...@gmail.com>
Subject RE: Unnecesery INNER JOIN
Date Fri, 16 Jul 2010 05:52:20 GMT

>From my point of view, there shouldn't be any joins and correct SQL output
should look like:
SELECT b.a_id FROM table_b b WHERE b.id = 123

I try to limit unnecesery joins in my queries, because in the case of
pessimistic locking this behavoiur locks too much.

By the way previously I was using hibernate and this framework doesn't add
unnecesery joins. 


-- 
View this message in context: http://openjpa.208410.n2.nabble.com/Unnecesery-INNER-JOIN-tp5297321p5300566.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Mime
View raw message