Exactly 1,000 orders
Your admin dashboard says you have 1,000 orders. It has said exactly 1,000 for three weeks.
This answers: Why does my Supabase query return only 1000 rows? No coding needed. 3 quick decisions.
- Keeping data safe
- How a request travels
Checking your access…
Why does my Supabase query return only 1000 rows?
's returns at most 1,000 rows per request by default, and it does not raise an error when it stops. Ask the database to count instead of downloading rows, and when you need every row, with a stable order such as created_at then id.
Breaks at Database: Silently capped at 1,000 rows
Why AI tools write this bug
Generated dashboards often load a whole table and count it in the browser, which works perfectly in testing with a few hundred rows.
How to fix it
- Use a count query instead of counting downloaded rows.
3 more steps, and a prompt that checks your own app for this bug. Part of Pro.
UnlockCommon questions
- Should I just raise the row limit?
- No. Every visit would download far more data, and it breaks again at the new limit.