Re: [PHP] Are left joins more efficient?

Dennis-- You might get a more authoritative answer from the mysql general discussion list at: http://lists.mysql.com --John On Monday 25 August 2003 12:59 pm, [EMAIL PROTECTED] wrote: Hello, I program for a website that gets massive loads of traffic. Optimisation has become an important

[PHP] Are left joins more efficient?

Hello, I program for a website that gets massive loads of traffic. Optimisation has become an important issue lately. At the moment, all queries on the website follow the same format when joining tables: SELECT * FROM table1,table2 WHERE table1.id=table2.id; My question is, would this format be

Re: [PHP] Are left joins more efficient?

THese are very different things, generally. The first join is an INNER join. It pulls all records that have the matching ids. The left join is an OUTER join. It pulls ALL records from table1, and any matching records from table2. This is useful if you want customer and address info, but

RE: [PHP] Are left joins more efficient?

[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] on Monday, August 25, 2003 9:59 AM said: At the moment, all queries on the website follow the same format when joining tables: SELECT * FROM table1,table2 WHERE table1.id=table2.id; My question is, would this format be more efficient? SELECT *