Thanks for the reply everyone.
In my case, it looks like there is no real drawback then, since what used
to happen is:
SELECT a,b,c
FROM table
WHERE clauses
OFFSET x LIMIT y;
followed by:
SELECT COUNT(*) FROM (
SELECT a,b,c
FROM table
WHERE clauses
);
(notice the lack of OFFSET and LIMIT)
Hi all,
Recently, during a performance improvement sweep for an application at my
company, one of the hotspots that was discovered was pagination.
In order to display the correct pagination links on the page, the
pagination library we used (most pagination libraries for that matter) ran
the query
