[Bug]: Add to Cart is very slow in production

[kb-0912]

Package.json file

{
  "name": "medusa-next",
  "version": "1.0.3",
  "private": true,
  "author": "Kasper Fabricius Kristensen <kasper@medusajs.com> & Victor Gerbrands <victor@medusajs.com> (https://www.medusajs.com)",
  "description": "Next.js Starter to be used with Medusa V2",
  "keywords": [
    "medusa-storefront"
  ],
  "scripts": {
    "dev": "next dev --turbopack -p 8000",
    "build": "next build",
    "start": "next start -p 8000",
    "lint": "next lint",
    "analyze": "ANALYZE=true next build"
  },
  "dependencies": {
    "@headlessui/react": "^2.2.0",
    "@medusajs/js-sdk": "latest",
    "@medusajs/ui": "latest",
    "@radix-ui/react-accordion": "^1.2.1",
    "@stripe/react-stripe-js": "^1.7.2",
    "@stripe/stripe-js": "^1.29.0",
    "lodash": "^4.17.21",
    "next": "15.0.3",
    "pg": "^8.11.3",
    "qs": "^6.12.1",
    "react": "19.0.0-rc-66855b96-20241106",
    "react-country-flag": "^3.1.0",
    "react-dom": "19.0.0-rc-66855b96-20241106",
    "server-only": "^0.0.1",
    "swiper": "^11.2.1",
    "tailwindcss-radix": "^2.8.0",
    "vn-provinces": "^1.0.4",
    "webpack": "^5"
  },
  "devDependencies": {
    "@babel/core": "^7.17.5",
    "@medusajs/types": "latest",
    "@medusajs/ui-preset": "latest",
    "@types/lodash": "^4.14.195",
    "@types/node": "17.0.21",
    "@types/pg": "^8.11.0",
    "@types/react": "^18.3.12",
    "@types/react-dom": "^18.3.1",
    "@types/react-instantsearch-dom": "^6.12.3",
    "ansi-colors": "^4.1.3",
    "autoprefixer": "^10.4.2",
    "babel-loader": "^8.2.3",
    "eslint": "8.10.0",
    "eslint-config-next": "15.0.3",
    "postcss": "^8.4.8",
    "prettier": "^2.8.8",
    "tailwindcss": "^3.0.23",
    "typescript": "^5.3.2"
  },
  "packageManager": "yarn@3.2.3",
  "resolutions": {
    "@types/react": "npm:types-react@19.0.0-rc.1",
    "@types/react-dom": "npm:types-react-dom@19.0.0-rc.1"
  },
  "overrides": {
    "react": "19.0.0-rc-66855b96-20241106",
    "react-dom": "19.0.0-rc-66855b96-20241106"
  }
}

Node.js version

v20.16.0

Operating system name and version

MacOS 14.6 (23G80)

Browser name

No response

What happended?

I'm using the starter template, in my local development it's very fast but on Vercel it takes a lot of time to response when I try to add to cart and return
FUNCTION_INVOCATION_TIMEOUT

Expected behavior

It should fast like local development

Actual behavior

I'm using the starter template, in my local development it's very fast but on Vercel it takes a lot of time to response when I try to add to cart and return
FUNCTION_INVOCATION_TIMEOUT

Link to reproduction repo

https://github.com/medusajs/nextjs-starter-medusa

[kb-0912]

It takes almost 30 seconds to add a product to cart.

My backend / redis / postgres all hosted on railway

[riqwan]

Hey @kb-0912, can you share which railway plan you are on and what your instance RAM, CPU, etc are?

[kb-0912]

Hey @kb-0912, can you share which railway plan you are on and what your instance RAM, memory, etc are?

I'm using railway pro with maximum Resource Limit of my plan for all istance

[riqwan]

Hm, thats odd. Would you be able to add me temporarily to your account? riqwan[at]medusajs[dot].com

[ItsWendell]

@riqwan @kb-0912 did you guys ever solve this, it's also taking up to 6 seconds for me on railway, almost everything uses internal network except for database which is hosted on Neon, I enabled database logging in Medusa Config and the queries are all 40-80ms. It's not workable to have add to cart actions that take over 10 seconds.

[riqwan]

@ItsWendell the database is the one that needs to be on the same network as the server. Which regions are they deployed to? server and db?

[ItsWendell]

@ItsWendell the database is the one that needs to be on the same network as the server. Which regions are they deployed to? server and db?

I actually noticed the deployments were further away, it wasn't automatically scheduling everything in the same region. Now that the worker, server and database are on the same server it's somewhat faster, but still takes about 1-2 seconds for the whole add to cart or update quantities to update. This is likely due to indeed the many steps the workflow has to go through and the many database queries it needs to execute. Curious if we can make this more efficient somehow by simplifying this workflow. Ideally this wouldn't take longer than 300ms.

Do you have any insights into which workflows are the most extensive in terms of the queries it needs to execute? E.g. in our case we don't need promotions, taxes, etc.

[kb-0912]

@ItsWendell the database is the one that needs to be on the same network as the server. Which regions are they deployed to? server and db?

this is worked for me

[octalpixel]

Getting this same issues, very strange. Both my DB and server is in the same region.