Specification, Pageable results and another totals alongside with count

[detinho]

A business requirement was presented to add totals to paged tables, demanding the summation of selected columns across all records, regardless of the displayed page.

The findAll(Specification, Pageable) method in Spring Data already executes two queries: one for the paginated data and another for the total count. I sought a way to optimize this process by calculating the totals within the same query, but found no native solution.

To avoid the overhead of an additional query, I implemented the pagination, count, and sum logic directly in the application, achieving the desired result.

I am opening this issue to check if this is a common use case and to discuss the feasibility of a generic solution within the framework itself.

[mp911de]

Counting totals uses an optimized mechanism that runs the count query only if it is necessary. When fetching a page and the page is not full, then we can determine the result count by calculating a total.

Any other approach would require analytic functions to be incorporated into the query. With JPA, it would be best to direct your question to the Hibernate team as they construct the actual SQL queries.