Add to cart very slow. | Medusa Community | Page 1

compact fiber Jun 15, 2023, 4:09 PM

#

My add to cart is very slow, does anyone know how I can fix this? The whole cart flow feels slow too selecting shipping, payment methods and what not.

lethal storm Jun 15, 2023, 5:52 PM

#

Not sure but for me was slower and sluggish in development but fast when deployed 🤷🏽‍♂️

compact fiber Jun 15, 2023, 6:28 PM

#

that is also true for me but still not as fast as I would like. I mean its slower then every other website I feel

safe quartz Jul 3, 2023, 9:13 AM

#

I agree with that - the cart is very slow and has a very high consumption of queries in DB. However I still need to upgrade to Medusa 1.8+ versions that might help. @compact fiber which version of medusa are you running ?

visual crane Jul 3, 2023, 9:14 AM

#

Cart is fast for me and i'm not even on 1.8 yet

#

Cart speed has been fixed like a year ago

#

I'm on 1.7.something

#

1.7.14?

#

whatever the latest at 1.7

visual crane Jul 3, 2023, 9:32 AM

#

Anyway I still advise to use React Query or medusa-react queries and leverage the loading state. Have spinners, loading states whenever the adding-to-cart (adding, modifying, deleting) request is happening. This will make the store speed perception feel faster.

safe quartz Jul 3, 2023, 10:40 AM

#

Hi @visual crane - yes I remember last year it was really slow and a fix was done that improved a lot the speed. But since few months my add to cart is slow again. It's since I am using tax product override I think.

I got these DB queries that are taking ages when in the checkout process

duration: 2568.129 ms

[DATABASE] [12-1] sql_error_code = 00000 time_ms = "2023-07-03 10:33:18.951 UTC" pid="1282253" proc_start_time="2023-07-03 10:32:42 UTC" session_id="64a2a3ca.1390cd" vtid="22/361401" tid="0" log_line="4" database="" connection_source="176.34.212.68(46238)" user="" application_name="[unknown]" LOG: duration: 2568.129 ms execute <unnamed>: SELECT "Cart"."id" AS "Cart_id", "Cart__region"."id" AS "Cart__region_id", "Cart__region"."created_at" AS "Cart__region_created_at", "Cart__region"."updated_at" AS "Cart__region_updated_at", "Cart__region"."deleted_at" AS "Cart__region_deleted_at", "Cart__region"."name" AS "Cart__region_name", "Cart__region"."currency_code" AS "Cart__region_currency_code", "Cart__region"."tax_rate" AS "Cart__region_tax_rate", "Cart__region"."tax_code" AS "Cart__region_tax_code", "Cart__region"."gift_cards_taxable" AS "Cart__region_gift_cards_taxable",

visual crane Jul 3, 2023, 10:56 AM

#

You can file an issue for that but I know the first answer will be to update to latest 🙂

compact fiber Jul 5, 2023, 4:09 PM

#

@safe quartz I am onn

#

on* 1.11

#

and here is a link to staging you can test it and see how it feels for you https://new.boardsource.xyz/

Home | Boardsource

Shop all available models only at the ACME. Worldwide Shipping. Secure Payment.

visual crane Jul 5, 2023, 4:11 PM

#

compact fiber and here is a link to staging you can test it and see how it feels for you https...

I'm adding to cart and getting 227ms response

#

Altought no

#

it takes 3-4 seconds.

compact fiber Jul 5, 2023, 4:13 PM

#

is that fast or slow? to you? it feels slow to me still the whole chain, add to cart fetch cart so on

#

is it slower then your site?

visual crane Jul 5, 2023, 4:14 PM

#

No, it was the preflight that took 227ms. Indeed adding to cart takies 3-4 seconds

#

Something is messed up

compact fiber Jul 5, 2023, 4:14 PM

#

ok cool well at least that, that means it can be fixed

#

could it be my server hosting?

visual crane Jul 5, 2023, 4:15 PM

#

Is it fast when you build it locally?

#

If yes, then it might be your server

compact fiber Jul 5, 2023, 4:16 PM

#

umm no it all feels about the same

#

good thinking on that

visual crane Jul 5, 2023, 4:17 PM

#

And what custom code have you added?

compact fiber Jul 5, 2023, 4:20 PM

#

ummmm for default add to cart no custom code.
I have a custom route for adding multiple items to cart.
but I havent messed with any cart code other then that. I mean there is lots of custom code all over the place but its mostly in products and such

visual crane Jul 5, 2023, 4:23 PM

#

Even a simple https://backend.boardsource.xyz/store/products takes a lot of time for me

#

Something is wrong with your deployment

compact fiber Jul 5, 2023, 4:26 PM

#

oh thats great news where should I look you think? am using digitalocean app platform setup off the docs for that.

visual crane Jul 5, 2023, 4:26 PM

#

200 OK
32.48 s

#

It took 32 seconds for that fetch

#

in Postman

#

I have no clue 🙂

compact fiber Jul 5, 2023, 4:28 PM

#

lol >.< ok im going to poke around thank you very much for your help. Do you have a medusa site I can look to feel your speeds?

compact fiber Jul 12, 2023, 8:33 PM

#

Do you think think could be from very large metadata in products?

safe quartz Jul 13, 2023, 11:06 AM

#

I've always had large metadata in variants and it was not an issue

mint delta Oct 22, 2023, 12:26 PM

#

@compact fiber did you end up solving your issue?

compact fiber Oct 25, 2023, 8:13 PM

#

haha yes I did database config problem

forest dawn Jan 17, 2024, 5:25 PM

#

@compact fiber Do you mind sharing what the solution was?

compact fiber Jan 22, 2024, 9:25 PM

#

forest dawn <@179101619084853249> Do you mind sharing what the solution was?

yeah our medusa backend server was in nyc and our postgress server was in SF

fossil spear Jan 23, 2024, 7:26 AM

#

Have you got all your redis and a search provider set up I use algolia self hosted on the same server and its really fast. I would recomend Digital Ocean Apps . Also is your postgres database on the same server I had similar issues unitill I hosted the backend and front end all on Digital ocean

fervent heart Jan 23, 2024, 8:22 AM

#

compact fiber yeah our medusa backend server was in nyc and our postgress server was in SF

same here, when backend server and postgress server not in same, SQL statement execution is slow， I guess it might have been caused by using too many transactions

#Add to cart very slow.