Gayner Posted September 1, 2009 Share Posted September 1, 2009 $DB->query("SELECT cl.*, f.id AS to_desktop, a.desktop as jesktop FROM ibf_faq AS cl INNER JOIN ibf_members AS f ON f.name = cl.editor INNER JOIN ibf_members AS a ON a.name = cl.editor where cid = $id "); Instead of keep putting more INNER JOIN ibf_members AS a ON a.name = cl.editor is there way to call all what i want from ibf_members instead of making new lines each time? Link to comment https://forums.phpfreaks.com/topic/172672-help-on-this-optimization/ Share on other sites More sharing options...
ignace Posted September 1, 2009 Share Posted September 1, 2009 denormalise parts of your db Link to comment https://forums.phpfreaks.com/topic/172672-help-on-this-optimization/#findComment-910152 Share on other sites More sharing options...
Gayner Posted September 1, 2009 Author Share Posted September 1, 2009 denormalise parts of your db lol that makes perfect sence.. ^^ Link to comment https://forums.phpfreaks.com/topic/172672-help-on-this-optimization/#findComment-910154 Share on other sites More sharing options...
ignace Posted September 1, 2009 Share Posted September 1, 2009 denormalise parts of your db lol that makes perfect sence.. ^^ Yeah it does. You create joins because of created relationships if you lower the number of relationships then so do your number of joins. If you don't know what denormalisation is then look up what db normalisation is (denormalisation is the reverse process). Link to comment https://forums.phpfreaks.com/topic/172672-help-on-this-optimization/#findComment-910156 Share on other sites More sharing options...
Gayner Posted September 1, 2009 Author Share Posted September 1, 2009 denormalise parts of your db lol that makes perfect sence.. ^^ Yeah it does. You create joins because of created relationships if you lower the number of relationships then so do your number of joins. If you don't know what denormalisation is then look up what db normalisation is (denormalisation is the reverse process). That's like telling nto to post here if i dont have a question.. Is there anyway u can asnwer my question man? about the database issue not denormailising.. thx Link to comment https://forums.phpfreaks.com/topic/172672-help-on-this-optimization/#findComment-910158 Share on other sites More sharing options...
ignace Posted September 1, 2009 Share Posted September 1, 2009 With an attitude like that no sorry can't help ya. Link to comment https://forums.phpfreaks.com/topic/172672-help-on-this-optimization/#findComment-910162 Share on other sites More sharing options...
Gayner Posted September 1, 2009 Author Share Posted September 1, 2009 With an attitude like that no sorry can't help ya. Attitude? your the one who started it.. Link to comment https://forums.phpfreaks.com/topic/172672-help-on-this-optimization/#findComment-910165 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.