Hi Alexandru, Torque does neither support explicit inner joins in the form JOIN x ON x.id = y.fk nor left nor right joins. Im currently working on this feature. I've done it two weeks ago for my company but I have to rewrite it before contributing the code. So if you can be patient for a few days ...
Happy Eastern to all of you. F. Fray Wuppertal, Germany ----- Original Message ----- From: "Alexandru Dovlecel" <[EMAIL PROTECTED]> To: "'Apache Torque Users List'" <[EMAIL PROTECTED]> Sent: Friday, April 09, 2004 11:00 AM Subject: JOIN vs WHERE > 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]
