asmith Posted April 27, 2008 Share Posted April 27, 2008 hey guys, in some book i've get this question, i would really appreciate someone help me with it , i can't get it properly : there's a group of articles table : grouparticle table : id title mother_subject articles table : Id Title Groupid activated star Date_update entereddate Int Varchar(30) int tinyint tinyint timestamp Datetime the question is : 1.what do you suggest for making this query load better or something like that : 2.what indexes you think its better to put? db->sql_query("SELECT articles.* from articles INNER JOIN grouparticle ON articles.groupid=grouparticle.id where (activated > '0' ) and star > 0 and (groupid=$gid or parent=$gid) order by star DESC "); Link to comment https://forums.phpfreaks.com/topic/103143-making-better-for-load-normalization/ Share on other sites More sharing options...
fenway Posted April 28, 2008 Share Posted April 28, 2008 Which db version? Post the EXPLAIN. Link to comment https://forums.phpfreaks.com/topic/103143-making-better-for-load-normalization/#findComment-528827 Share on other sites More sharing options...
asmith Posted April 28, 2008 Author Share Posted April 28, 2008 it meant i change the query to one without having join. is this right : SELECT * from articles,grouparticales where articles.groupid=grouparticle.id and activated > '0' ... still don't know about the "indexes". Link to comment https://forums.phpfreaks.com/topic/103143-making-better-for-load-normalization/#findComment-528870 Share on other sites More sharing options...
fenway Posted April 28, 2008 Share Posted April 28, 2008 it meant i change the query to one without having join. What? Is this a differnet question? I'm confused. Why would you want to change it? Link to comment https://forums.phpfreaks.com/topic/103143-making-better-for-load-normalization/#findComment-528875 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.