Supabase. Doing frontend pagination (because otherwise I won’t be able to get the total number of items per user, only the total items in the entire table).
You could do a separate query to count. It’s not like frontend pagination will make the requests faster if thats the issue because it still loads everything.
What is exactly the performance issue that you’re solving?