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 mo...@neadwerx.com | www.neadwerx.com
