`_limit` is breaking my app

System Information
  • Strapi Version: 3.6.8 (node v14.19.0)
  • Operating System: Heroku
  • Database: Postgresql

Hello, I have a broken app in production, please help.

when running _limit alone is taking so long that the app crashes

  • myapp.com/products?_sort=created_at%3Adesc&_limit=100 is totally fine
  • myapp.com/products?_limit=100 breaks the app

The limit increases the loading time exponentially:

  • limit: 10 - 2322ms
  • limit: 50 - 9479ms
  • limit: 60 - 11303ms
  • limit: 70 - 14087ms
    But I can’t get to 100 limit

But running: /products?_sort=created_at%3Adesc&_limit=100 returns 100 products in 609ms.

I’m using gatsby-source-strapi with Gastby so I can’t change the query.

The app has been running for 2 years, and no update made in the last 2 weeks. Is being used every day.

how many relations do you have?

A lot, products are linked to orders, each product is linked to around 3000 orders. There are like 600 products.

@DMehaffy moving to v4 could help?

Sorry to insist a little, would you mind comenting on this?