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) and R/W split enabled in the Poppy release. The goal of testing is to assess the performance of mod-lists along with other workflows (CICO and DI) and R/W split enabled and to measure mod-lists's impact on other modules
Ticket:
PERF-708 - Getting issue details... STATUS
Summary
Test runs
Query used in lists - "Item status != Available". List refresh result is 200K records.
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 |
*PTF Create 2 job was used for DI scneario
Results
| Transaction | Duration | Degradation | |||
|---|---|---|---|---|---|
| R/W split disabled | R/W split enabled | ||||
Testing separately (ListApp and DI+CICO) | Testing in parallel | Testing separately (ListApp and DI+CICO) | Testing in parallel | ||
| ListApp refresh, avg | 8.5 min | 17.7 min | 7.5 min | 11.4 min | |
| Check-in, avg | 1.173 sec | 1.290 sec | 0.992 | 1.087 | |
| Check-out, avg | 1.648 sec | 1.948 sec | 1.634 | 1.765 | |
| DI Create 25k | 18 min | 22 min | 13 min | 15 min | |
Grafana results
DI + CICO
ListApp + DI + CICO
Service CPU Utilization
ListApp
DI + CICO
ListApp + DI + CICO
Memory Utilization
ListApp
DI + CICO
ListApp + DI + CICO
DB CPU Utilization
ListApp
DI + CICO
ListApp + DI + CICO
DB Connections
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