<tr*********@gmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...
Does linking tables with JOIN offer any significant performance
advantage or does it just make things more simple from a programming
standpoint?
MySQL and other databases are *highly optimized* to do JOINs efficiently.
I would turn your question around a bit and say there are no performance
*disadvantages* to using JOINs with lots of great programming reasons to
take advantage of them.
The excuses people make to avoid learning table JOINs !
Of these, the lamest is an unwillingness to take a performance hit involved
with using JOIN. What performance hit? These amateurs take a performance
hit bigtime in lousy database design that always results from JOIN
avoidance.
JOINS are your friend ;-)
Thomas Bartkus