Application Performance Has Decreased

General
1

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);

2

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?
4
  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

5

@qnb Any specific endpoint?

6

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

7

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)

image
image2256×612 41.6 KB

image
image2242×601 40.8 KB

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

image
image2233×592 45.7 KB

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.