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.
Ticket: PERF-691 - Getting issue details... STATUS
Summary
Recommendations and Jiras
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 | |
|---|---|---|---|
| Testing separately | Testing in parallel | ||
| ListApp refresh, 95 perc | 8.7 min | 18.8 min | +116% |
| Check-in, 95 perc | 1.353 sec | 1.506 sec | +11.3% |
| Check-out, 95 perc | 1.899 sec | 2.223 sec | +17% |
| DI Create 25k | 18 min | 22 min | +22% |
Grafana results
Instance CPU Utilization
Service CPU Utilization
Memory Utilization
DB CPU Utilization
DB Connections
Additional info
Grafana graphs:
List App + Check-in/Check-out + Data Import Create
Check-in/Check-out + Data import