Replies: 1 comment 2 replies
-
Supabase is limiting that to 1000000. You would need to discuss with support if it can be changed for your instance. But, it seems like a bad idea to download a million rows for performance and egress cost reasons. Can you do this calculation in SQL in a postgres function and return the result instead? |
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I realize that there's max rows set of API to fetch data from supabase.
It was set as 1000, so I need to remove it since I have to calculate with fetched data's length.
but max of max rows setting is 1000000.
then what if data length is over 1000000?
Is there any way to remove max rows setting?
Beta Was this translation helpful? Give feedback.
All reactions