Any suggestions on how to get the count of all records that could be
returned
We use a window function to get the total # of records within each of
our paginated queries:
SELECT
...
,COUNT(*) OVER() fullRowCount
FROM ...
WHERE ...
ORDER BY ...
LIMIT ... OFFSET ...;
While there is a
The main search screen of my application has pagination.
I am basically running 3 queries with the same where clause.
1. Totals for the entire results(not just the number of rows on the
first page)
a. 300 ms
2. Subset of the total records on that page.
a. 1-2 sec
3. Count of the
The main search screen of my application has pagination.
I am basically running 3 queries with the same where clause.
1. Totals for the entire results(not just the number of rows on the
first page)
a. 300 ms
2. Subset of the total records for one page.
a. 1-2 sec
3. Count of the
* Jason Long (ja...@octgsoftware.com) wrote:
The main search screen of my application has pagination.
http://www.depesz.com/index.php/2007/08/29/better-results-paging-in-postgresql-82/
Thanks,
Stephen
signature.asc
Description: Digital signature