db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andras Balogh <and...@reea.net>
Subject Re: JOIN vs WHERE
Date Fri, 09 Apr 2004 12:18:35 GMT
    Hello Alexandru,

    Torque does support join by using criteria.addJoin().
What is  not supported (as far as i know) to specify the join type 
(left, right etc.)
The Sql that is generated is something like:
select * from table1,table2 where table1.id= table2.other_id
    This will be interpreted by the Database as a inner join.

Best wishes,

PS. Happy Easter!
 (Paste Fericit!:))

Alexandru Dovlecel wrote:

>Hi all,
>Question: does the Torque generate queries with JOIN??? Or when it cames to
>joining tables, it creates an where clause???
>AFAIK, if generating where clauses instead of joins, IT COULD LEAD to
>performance problems. Using JOIN is recommended instead of plain where
>clauses. Am I right? In case of large tables (lots of data), a couple of
>where clauses to join some tables would slow down the application quite
>Pls correct me if I am wrong. Better to find out now that I am wrong than
>having wrong ideas in my mind.
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message