db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexandru Dovlecel" <alexandru.dovle...@siemens.com>
Subject JOIN vs WHERE
Date Fri, 09 Apr 2004 09:00:19 GMT
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


Mime
View raw message