mike12255 Posted October 10, 2009 Share Posted October 10, 2009 So i currenlty have a really slow page and i think its beacuse all the diffrent querys i run on the db. So i was wondering if it was possible to combine a COUNT(*) so i still get the total number of entires with a limit on another thing. Basically im just trying to combine the code below. <?php $count = mysql_result(mysql_query("SELECT COUNT(*) FROM skillsoverall"),0) or die(mysql_error()); $query = mysql_query ("SELECT playerName FROM skillsoverall ORDER BY lvl DESC limit $from, $ppls_page") or die(mysql_error()); ?> Link to comment https://forums.phpfreaks.com/topic/177202-solved-combining-count-in-query/ Share on other sites More sharing options...
.josh Posted October 10, 2009 Share Posted October 10, 2009 you cannot combine those, because you have a limit in your 2nd query. count(*) will only return $ppls_page. Link to comment https://forums.phpfreaks.com/topic/177202-solved-combining-count-in-query/#findComment-934324 Share on other sites More sharing options...
mike12255 Posted October 10, 2009 Author Share Posted October 10, 2009 dang, i have a bunch of queries like this running so it really slows down my page, thanks. Link to comment https://forums.phpfreaks.com/topic/177202-solved-combining-count-in-query/#findComment-934328 Share on other sites More sharing options...
.josh Posted October 10, 2009 Share Posted October 10, 2009 well you only showed 2 queries. maybe if you showed all of them, others might be able to be combined. Link to comment https://forums.phpfreaks.com/topic/177202-solved-combining-count-in-query/#findComment-934333 Share on other sites More sharing options...
PFMaBiSmAd Posted October 10, 2009 Share Posted October 10, 2009 If the number of rows in the table is not going to change during a typical visit to your site, you should save the $count as a session variable to avoid repeating the first query on each page request. Does your second query have proper indexes setup so that it executes as efficiently as possible? Link to comment https://forums.phpfreaks.com/topic/177202-solved-combining-count-in-query/#findComment-934335 Share on other sites More sharing options...
mike12255 Posted October 10, 2009 Author Share Posted October 10, 2009 they example i posted didnt, but my real code does have proper indexes Link to comment https://forums.phpfreaks.com/topic/177202-solved-combining-count-in-query/#findComment-934339 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.