| From: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Counting all results before LIMIT |
| Date: | 2012-10-05 14:29:54 |
| Message-ID: | CAJ4CxLmpD5g=NGE=3zBKNO0ARgMCggKZNJgbqywctsOuEQrWNA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)neadwerx(dot)com | www.neadwerx.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | P Gouv | 2012-10-05 14:52:00 | Add a stemmer for fts |
| Previous Message | Merlin Moncure | 2012-10-05 13:55:18 | Re: Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? |