[SOLVED] combining count(*) in query

[mike12255]

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());

?>

[.josh]

you cannot combine those, because you have a limit in your 2nd query.  count(*) will only return $ppls_page.

[mike12255]

dang, i have a bunch of queries like this running so it really slows down my page, thanks.

[.josh]

well you only showed 2 queries.  maybe if you showed all of them, others might be able to be combined.

[PFMaBiSmAd]

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?

[mike12255]

they example i posted didnt, but my real code does have proper indexes