Hi, I'm using the free Supabase tier, and I notice...
# help
s
Hi, I'm using the free Supabase tier, and I noticed that sometimes (seems random), some queries can take longer to resolve (sometimes up to 10-15 seconds). It's not a specific query; sometimes it is a data mutation query, sometimes it is a fetch data query. After refresh same query resolves in less than second ( ~400ms is average). Not sure why this is happening, maybe because it is a free tier? I'm 1000 km away from the server where Supabase is hosted (Frankfurt) . Can that be the cause of these spikes?
n
Hello @stjepan! 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
Can you give an example of a query you are running?
n
stjepan (2022-04-13)
s
Copy code
supabase
    .from("memories")
    .select("*, createdBy( id, avatarUrl, firstName, lastName )")
    .eq("slug", slug);
Copy code
supabase.auth.api.getUser(token); // <- this is most likely to run slow
Copy code
supabase
      .from("memories")
      .update([{ likes: data[0].likes.filter((id) => id !== userId) }])
      .match({ id: memoryId });