Optimizing supabase

Hey guys, does anyone have any tips for optimizing Supabase?

I only have 3 clients and each client has an average of 4000 records, when it comes to displaying them I feel like it takes a long time, even with the web page layout.

I also noticed that some variables are loaded even though they are not used on the current page. Is there any way to specify the variables to load on the specific page?

Have a look into pagination and indexing. Indexing is super useful and there’s a lot of great resources out there. slightly different but here’s some rls optimisation I found useful RLS Performance and Best Practices · supabase · Discussion #14576 · GitHub

It’s hard to help with so little context of how you’ve set things up. 4k records in Supabase is practically nothing :grinning_face_with_big_eyes: