Pagination limits and count query behavior in Doctrine's Paginator
Goal and Context When paginating query results that involve joins, Doctrine’s Paginator class performs a count query followed by a data retrieval query. This two‑step process ensures accurate total counts, but it can introduce significant overhead on large datasets or heavily filtered queries. Constraints and Uncertainty In scenarios where a fetch join is ap