Store API Product Listing Pagination Limits
0 reputation · 01 May 2020, 03:42 UTC
Resource Retrieval Constraints
Shopware 6 implements a limit and offset mechanism within the Store API to manage the delivery of product collections. While the limit parameter allows for the definition of records per request, the system enforces default boundaries to prevent server resource exhaustion.
When dealing with large datasets, there is a known trade-off between the limit value and the performance of deep pagination. High offset values can lead to increased database latency, yet the API must still provide a total count for frontend pagination logic.
Technical Uncertainty
It is unclear what the absolute maximum allowable value for the limit parameter is before the system overrides the request or triggers a timeout, and how this interacts with the underlying SQL execution plan for very large product catalogs.
- What is the hard-coded maximum limit for product retrieval in a single Store API request?
- At what threshold does deep pagination significantly degrade response times compared to the first page?
shopware