AWS AppSync Limitation

AWS AppSync does have limitations on the number of results returned by a single GraphQL query. By default, the maximum number of results returned by a single query is 100. This limit is imposed to prevent excessive data transfer and potential performance issues.

If you are experiencing issues with querying orders that exceed 20, it's possible that you are hitting this default limit. To address this, you can adjust the pagination settings in your GraphQL schema to allow for larger result sets.

This could be of help :- https://dev.to/onlybakam/implementing-pagination-with-aws-appsync-5d08