Slow Server Response Times for Add to Cart Button | Medusa Community | Page 1

storm timber Nov 1, 2024, 7:12 PM

#

Hi everyone,

I’m a beginner developer; this is my first time working with Medusa. I’m building an online store with Medusa as the backend and a custom Next.js as the frontend, connected to a Supabase Postgres instance. I’m getting a significant server response delay when I try to add items to the cart.

Issue Details:

•    When “Add to Cart” is clicked, the server takes up to 12 seconds to respond (yes, it's a lot), with long waiting times in the network tab despite a 200 OK status
•    I’m using fetch to send a POST request to /store/carts/{cart.id}/line-items with credentials: "include" and an API key header

What I’ve Tried:

1.    Increased the logging level in Medusa to debug, but it only logs the initial click and task completion 12 seconds later without details.
2.    Checked Supabase database performance but couldn’t find specific slow queries
3.    Ensured indexing on Postgres, though I’m not sure it’s fully optimized for Medusa (I guess so)
4.    Looked into the Server Timing API with Firefox profiler) to monitor performance but need help interpreting the data. Link: https://share.firefox.dev/48u7zXu

Tech Stack:

•    Backend: Medusa with Supabase Postgres
•    Frontend: Next.js, Tailwind CSS

I’d greatly appreciate guidance on resolving this, especially optimizing Medusa’s setup to improve response times. If anyone has experience with Medusa + Supabase or logging more detailed steps, your insights would be very helpful.

Thanks in advance for any advice you can share 🙂

#

Slow Server Response Times for “Add to Cart” in Medusa

#

Slow Server Response Times for Add to Cart Button

pale sierra Nov 1, 2024, 8:35 PM

#

server specs running medusa ?

#

assuming you're on a dev instance of supabase ?

storm timber Nov 1, 2024, 8:57 PM

#

I’m running Medusa on a 2024 MacBook Air M3/ 16GB RAM/ macOS Sequoia 15.1. And yes, I'm running a dev instance of supabase free tier plan

pale sierra Nov 1, 2024, 9:10 PM

#

Also is projected started as dev or start?

#

dev is a little slower vs start

#

when adding to the cart, but I have my prod env on a $25 supabase account and it adds relatively quickly

crisp beacon Nov 1, 2024, 9:11 PM

#

@storm timber in dev it works quite slow

#

but when u move to prod

#

with 4 or 2 gb ram postgres

#

it works super smooth

storm timber Nov 1, 2024, 9:11 PM

#

but 12 seconds? haha

crisp beacon Nov 1, 2024, 9:11 PM

#

also whenever deploying the applications, make sure to place the db and server in same network

pale sierra Nov 1, 2024, 9:12 PM

#

storm timber but 12 seconds? haha

id say my prod instance is sub <1.5s

#

while my dev instance let me test now and give you exacts

storm timber Nov 1, 2024, 9:13 PM

#

yes, but 12 seconds is an expected and reasonable time in dev?

pale sierra Nov 1, 2024, 9:14 PM

#

yeah, my dev instance is 10.59s

crisp beacon Nov 1, 2024, 9:14 PM

#

storm timber yes, but 12 seconds is an expected and reasonable time in dev?

you should use local postgres

#

in dev

#

it would speed up the process for you

storm timber Nov 1, 2024, 9:19 PM

#

It may be a good idea. I just wanted to know if there was a problem since I don't have any point of comparison, so I first assumed there was a bottleneck in the server

#

But I'm more confident if you say it could be expected in a dev instance

pale sierra Nov 1, 2024, 9:23 PM

#

just tested my prod instance with supabase, < .55s

chilly kestrel Dec 2, 2024, 3:14 PM

#

@storm timber did you have any luck improving times? Mine are super slow as well, it takes around 15 sec to add an item to cart and I am talking on both, production and dev.

storm timber Dec 2, 2024, 6:22 PM

#

chilly kestrel <@171799178148708352> did you have any luck improving times? Mine are super slow...

I just changed the development to a local db for now. I just told myself that the future me will solve the problem haha. But I thought it would just be on dev, not production. So let's keep in touch!

nimble sparrow Feb 13, 2025, 4:54 AM

#

chilly kestrel <@171799178148708352> did you have any luck improving times? Mine are super slow...

did you relsove it? i have same problem

chilly kestrel Feb 13, 2025, 5:00 AM

#

nimble sparrow did you relsove it? i have same problem

Yes, the issue was having the database in a different region/enviroment. Before I had the medusa app (server and admin) and the Redis on Railway in X region and the postgres database in Neon in Y region.

What I did was to create a new postgress database in the same region and server in Railway and then moved the one in Neon to Railway, and it fixed the issue. Now it is fast

nimble sparrow Feb 13, 2025, 5:01 AM

#

chilly kestrel Yes, the issue was having the database in a different region/enviroment. Before ...

In my case the backend is response fast but on vercel it say FUNCTION_INVOCATION_TIMEOUT. Do u know why?

chilly kestrel Feb 13, 2025, 5:03 AM

#

the timeout is due to the responses taking too long

#

Where do you have the postgress database?

nimble sparrow Feb 13, 2025, 5:09 AM

#

backend / redis / postgres everything is on railway

#

only store front on vercel

#

backend response

chilly kestrel Feb 13, 2025, 5:57 AM

#

and do you have everything in the same region?

#Slow Server Response Times for Add to Cart Button