Appsync GraphQL page limit

[elusivestudio]

‼️ Critical issue: page limit is broken. I get different results after adding limit and it strangely changes by the limit number.

These are the 3 example at the same time.

[sashee]

If you happen to use DynamoDB for this then it might very well because of the combination of filtering along with limiting in the DB query. I wrote an article about this not long ago that looks into a scenario that returns similarly surprising results: https://advancedweb.hu/the-surprising-properties-of-dynamodb-pagination/

[ATaiIsHere]

The limit parameter in DynamoDB API represents the number of items that will be scanned.

If you can provide the logic of resolver, we can have better idea of what the problem might be.

[onlybakam]

@elusivestudio Let us know if you are still experiencing this issue