Write Record take too long to execute

Certified Senior Developer

Hi All,

We're executing load tests on our testing environment. We notice that during the high peak, simple operations like write or query records take longer to execute (2-4 sec).

The CPU memory utilization of the instance is very high too.

The records are light weighted and not heavy to take this long.

Any ideas as to what might be the cause of this slowness and how to debug this?

Regards,

Sakshee

  Discussion posts and replies are publicly visible

Parents Reply
  • 0
    Certified Lead Developer
    in reply to vikrantb

    The data fabric doesn't have a way to compartmentalize / ensure quality of service for users over non-users, or even one app over another. It would be nice if we could have priorities for queries, but those would mask a larger scalability problem in how you've setup your system.
    First, run through the 'Scaling Appian' page and triple-check the results on your performance testing environment.
    https://docs.appian.com/suite/help/25.2/Scaling_Appian.html

    If your architecture/hardware seem to be correctly sized and configured, there are some additional questions to ask/answer about how you're using the data fabric. Could you elaborate on the frequency and types of calls made to the data fabric? For example, are your performance tests UI/user-based, or are they API-based?

Children
No Data