db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Florian Fray" <florianf...@compuserve.de>
Subject Re: JOIN vs WHERE
Date Sat, 10 Apr 2004 19:00:05 GMT
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" <alexandru.dovlecel@siemens.com>
To: "'Apache Torque Users List'" <torque-user@db.apache.org>
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: 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


Mime
View raw message