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? Quote 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 Quote 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.. ^^ Quote 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). Quote 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 Quote 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. Quote 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.. Quote Link to comment https://forums.phpfreaks.com/topic/172672-help-on-this-optimization/#findComment-910165 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.