Counting all results before LIMIT

[Moshe Jacobson <moshe@xxxxxxxxxxxx>]

We have a PHP web application that pulls results from the database and paginates them.

We show e.g. "1-50 of 300" so the user knows how many total results there are, and which ones are currently being displayed.

To achieve this, we use a query with LIMIT...OFFSET to get the displayed results, and we do another identical query using count(*) to get the total count.

Is there a more efficient way to do this that does not require us to do two queries? I just feel that it's a waste of resources the way we do it.

Thanks!

--

Moshe Jacobson
Nead Werx, Inc. | Senior Systems Engineer

2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@xxxxxxxxxxxx | www.neadwerx.com