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, Andras.
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 allot.
Pls correct me if I am wrong. Better to find out now that I am wrong than having wrong ideas in my mind.
10q, Alex
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
