db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Florin Vancea" <fvan...@maxiq.ro>
Subject Re: JOIN vs WHERE
Date Fri, 09 Apr 2004 12:13:25 GMT
(Hi Alex! How are you lately?)

Maybe it's a vendor-related issue. For example Oracle gets away very well
with WHERE (actually I cannot tell if there's a way to support JOIN, at
least not in older releases...)

IMHO, the DB should figure its way offering the same level of performance,
either when using JOIN or WHERE, as long as they are both supported in the
first place. But then maybe this is only common sense and not supported by
some standard I did not bother to read.

Florin

----- Original Message ----- 
From: "Alexandru Dovlecel" <alexandru.dovlecel@siemens.com>
To: "'Apache Torque Users List'" <torque-user@db.apache.org>
Sent: Friday, April 09, 2004 12:00 PM
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