@KyleG-Shopify There doesn’t seem to be a maximum value for the LIMIT statement currently.
I did a test of LIMIT 1000000000 expecting an error from the API and I didn’t get any errors and returned everything on our test store:
Even in the Shopify Admin, the help text mentions 1000, but I can change to 10000 and it returns all 10k records on the page:
Is there a plan to put a maximum to the LIMIT statement in the future? Or is there a recommendation from Shopify Engineering for a maximum LIMIT value to prevent potential issues in the future (such as timeout errors)?
We’ll probably play it safe when we add this feature to our app and just do LIMIT 1000 at a time with OFFSET += LIMIT to paginate, but I’m curious how high we can reasonably set the LIMIT for without breaking things in the future.