What is the performance impact of Shopware's offset-based pagination when querying large datasets with Criteria::limit()?
Shopware 6.x Pagination Performance with Large Datasets Shopware 6.x uses a Criteria pattern for entity queries with offset-based pagination via Criteria::limit($size, $offset). When retrieving paginated results, the framework executes a separate COUNT query to calculate the total number of records, which can become expensive for large datasets, especially w
shopware