Application Performance Has Decreased

The performance of developed application has decreased seriously since the last month (approximately 3 times slower across all business processes on the project). Project ID: 361102

The most noticeable decrease in performance was found in the getPlace 1 business process (where all types of filtering and logic are concentrated);

To check we need additional information from you:

  • During what operation you facing slower performance? Web BP or Backend BP?
  • Please share your BP logic
  • Any heavy DB operations? How many rows in your tables?
  • Is it old instance or freshly deployed version?
  1. Backend BP
  2. I am not sure there is any reasonable way to do this. Business process itself is pretty huge and contains 4-5 additional BPs inside.
  3. DB operations are relatively simple, but there are lots of them (100~200). Likely they cannot be unified.
  4. Freshly deployed.

The whole point is that it was working pretty fast just 1 month ago, there were no development during that time.

11/28/2024 11:46 AM 11/28/2024 11:47 AM
Completed
1m 2s
Epic Day
11/07/2024 11:59 AM 11/07/2024 12:00 PM
Completed
1m 5s

@qnb Any specific endpoint?

GET /place/ - This one on average is executed in 10s with params

We’ve checked overall performance of your app and here is our findings:
Very high database rpm (requests per minute) with spikes (probably during your API calls)


Up to 18,000 requests per minute (300 DB requests per second) that’s insanely large number for such a small project - check your logic. There is a chance, that if your records count is growing, number of your requests grows exponentially due to the flawed logic.

Your logic gets a lot of values from the DB up to 1.5m

While there are a number of DB-related optimizations we can advise, but that’s useless until you will fix your logic.

If you don’t have engineer in your team or contractor, you can use AppMaster Professional Services.