Baseball Posted December 25, 2009 Share Posted December 25, 2009 1) I have 2 tables, which i just need to do use SELECT id from table1 were ID = bla bla 2) I innerjoin those 2 tables together? Is it more effeciant for mysql resources to just select what i need from the 2 different tables? Or inner join or left join more efficiant? or it wont really matter? lol Link to comment https://forums.phpfreaks.com/topic/186312-which-is-more-effeciant/ Share on other sites More sharing options...
ignace Posted December 25, 2009 Share Posted December 25, 2009 Joining two tables isn't much of a concern the cartesian product however is: the more rows it has to return the slower it will become. inner join != left join != right join an inner join will add two records to the result if they have a match left and right join will return all rows from the left or right table regardless if they have a match. Link to comment https://forums.phpfreaks.com/topic/186312-which-is-more-effeciant/#findComment-983987 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.