How do you increase speed in loading of data in Su...
# help
m
How do you increase speed in loading of data in Supabase? We have noticed that it takes a long time to load the db. I don't know if it's cause by vercel or by supabase but most probably supabase because it's just waiting for data to load. Stack use: Nuxtjs, Supabase, Vercel Thanks 🙂
n
Hello @Michie! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the
/title
command! We have solved your problem? Click the button below to archive it.
s
i am seeing speed around 50-80ms, what is it for you?
n
Michie (2022-04-05)
s
for API's
also please provide more context
m
Here's a screenshot of the speed when fetching data.
All of those requests are supabase
b
you do know how that works right
could be many many reasons
poop internet
living in the middle of the jungle or desert far away from the server
s
@Michie can you share the query?
And what location is the instance setup?
m
Hi @User , looks like it's ok again. My instance is in ap-southeast-1. Thank you for looking into this issue. Current internet speed: 85 mbps for download @User yup i'm aware of that. But sometimes even if I have good internet connection, supabase takes time to load and I don't know why and i'm questioning if it's my internet, something wrong with my code, or supabase db is having issues. And i'm also wondering if others have experience the same thing.
s
it depends on queries also, you can paginate. currently i am paginating 10 rows on every call for my news feed app and it works great.
also initial query may take upto 200-300 ms, but once its cached you should see results below 50ms