Slow API fetch, both in dev and prod

[crnls]

The last few days I have been trying to fix extremely slow API fetch issues with my Medusa store. I have tried many obvious solutions, but so far without success. Screenshots below with logs, there are no console errors. Add to cart often takes +6 seconds, simple product pages 2-4 seconds.

Notes:

• Locally, with external DB, API is also slow
• Admin API is fast
• Backend at Heroku (https://dev.wantsandneeds.nl/)
• Admin & Storefront hosted at Vercel (Vercel functions now build at Frankfurt server) (https://admin.wantsandneeds.nl/ & https://wantsandneeds.nl/)
• Database at Supabase (Frankfurt, closest to traffic (Netherlands))
• Tested everything also in clean install, also slow fetch there.
• Tested several DB providers (AWS RDS, multiple Supabase servers etc)
• Cart interactions are especially slow

Screenshots:

[bqst]

Since the switch to the new starter pack and server actions, I've been facing the same issue. The actions, especially the 'add to cart' one, now take a significantly longer time (~2 sec) with the same backend.

[VariableVic]

Is it just as bad when you interact with the server directly? E.g.

curl -X POST '{backend_url}/store/carts/{id}/line-items' \
-H 'Content-Type: application/json' \
--data-raw '{
    "variant_id": "{variant_id}",
    "quantity": 1
}'

I'm running the same setup for next.medusajs.com. The only difference is that I host Redis and Postgres on Heroku instead of Supabase. So that might be the bottleneck here.

Still weird, since you tried several DB providers. Really hard to tell what's causing this bad performance.

[crnls]

Hey Victor, Redis is for me also at Heroku, db Supabase. This shouldn’t be an issue right? When I interact with the server directly, the load is about 2 seconds. Groet, Martijn van der Pas Op 14 mrt 2024 om 12:31 heeft Victor Gerbrands ***@***.***> het volgende geschreven:  Is it just as bad when you interact with the server directly? E.g. curl -X POST '{backend_url}/store/carts/{id}/line-items' \ -H 'Content-Type: application/json' \ --data-raw '{ "variant_id": "{variant_id}", "quantity": 1 }' I'm running the same setup for next.medusajs.com. The only difference is that I host Redis and Postgres on Heroku instead of Supabase. So that might be the bottleneck here. Still weird, since you tried several DB providers. Really hard to tell what's causing this bad performance. — Reply to this email directly, view it on GitHub<#280 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AEL5BM63ESTYSY75JNK4ZUTYYGC7ZAVCNFSM6AAAAABD2FWQP6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOJXGIZTQMBXGA>. You are receiving this because you authored the thread.Message ID: ***@***.***>