Overview
This document contains the results of testing List App refreshing of 200k records with multiple parallel workflows (Check-in/Check-out and Data import) in the Poppy release. The goal of testing is to assess the performance of mod-lists along with other workflows (CICO and DI) and to measure mod-lists's impact on other modules
Ticket: PERF-691 - Getting issue details... STATUS
Summary
- ListApp refreshing duration is about 8.5 min when testing separately from other workflows. With Data Import and Check-in/Check-out scenario ListApp duration has +108% increase and reaches 17.7 min. It's above the expected value of 10 minutes.
- Data Import and Check-in/Check-out response time also increase about 10-20% with ListApp scenario added.
- According to the results, CPU utilization for DI + CICO test was about 80%, while with ListApp scenario added CPU reached 155%.
- RDS CPU utilizatoin is about 90% for DI+CICO test and it doesn't increase with ListApp scenario added.
Test runs
| Scenario | Data quantity |
|---|---|
| List App* + Check-in/Check-out + Data Import Create** | ListApp - 10 users CICO - 20 users DI - 25k |
| Check-in/Check-out + Data import** | CICO - 20 users DI - 25k |
| List App | ListApp - 10 users |
*200k records list refresh for each user.
**PTF Create 2 job was used for DI scneario
Results
| Transaction | Duration | Degradation | ||
|---|---|---|---|---|
[Orchid] Testing separately | [Poppy] Testing separately (ListApp and DI+CICO) | [Poppy] Testing in parallel | ||
| ListApp refresh, avg | from 9 min 40 sec to 10 min 40 sec | 8.5 min | 17.7 min | +108% |
| Check-in, avg | 1.173 sec | 1.290 sec | +9.9% | |
| Check-out, avg | 1.648 sec | 1.948 sec | +18.2% | |
| DI Create 25k | 18 min | 22 min | +22% | |
Grafana results
Instance CPU Utilization
ListApp
DI + CICO
ListApp + DI + CICO
Service CPU Utilization
According to the results, CPU utilization for DI + CICO test was about 80%, while with ListApp scenario added CPU reached 155%.
ListApp
DI + CICO
ListApp + DI + CICO
Memory Utilization
No memory leacks were found during the tests.
ListApp
DI + CICO
ListApp + DI + CICO
DB CPU Utilization
RDS CPU utilizatoin is about 90% for DI+CICO test and it doesn't increase with ListApp scenario added.
ListApp
DI + CICO
ListApp + DI + CICO
DB Load
ListApp
DI + CICO
ListApp + DI + CICO
Additional info
Grafana graphs:
List App + Check-in/Check-out + Data Import Create
Check-in/Check-out + Data import