[Poppy vs Quesnelia] - Performance tests for scenario create Order + PO lines -> create Invoice + INV Lines
- 1 Overview
- 2 Summary
- 3 Test Results
- 4 Comparison
- 5 Resource utilization for Test #1
- 6 Resource utilization for Test #2
- 7 Resource utilization for Test #3
- 8 Resource utilization for Test #4
- 9 Resource utilization for Test #5
- 10 Resource utilization for Test #6
- 10.1 Service CPU Utilization
- 10.2 Service Memory Utilization
- 10.3 DB CPU Utilization
- 10.4 DB Connections
- 10.5 DB load
- 10.6 Top SQL-queries
- 11 Appendix
- 11.1 Infrastructure
- 11.2 Methodology/Approach
- 12 Attached files
Overview
This document contains the results of testing scenario to create order with PO lines plus create invoice with invoice Lines for both Poppy and Quesnelia environments. Tickets: PERF-788 and PERF-891
https://folio-org.atlassian.net/browse/PERF-788 https://folio-org.atlassian.net/browse/PERF-891
Summary
When comparing Test №1 (Poppy) and Test №4 (Quesnelia), we observed an overall improvement in performance across all requests. Additionally, during the same 1.5-hour test duration, Test №3 (Quesnelia) processed 39 more orders, totaling 390 order lines, and 39 more invoices, totaling 379 invoice lines, compared to Test №1 (Poppy).
Comparing Test №2 (Poppy) and Test №5 (Quesnelia), we observed a similar improvement in performance across all requests. Moreover, we noted improvements ranging from 20 to 57 seconds for certain requests. Additionally, Test №2 (Poppy) lasted 3 hours and 10 minutes, while Test №5 (Quesnelia) lasted 1 hour and 8 minutes under the same test conditions.
In the comparison between Test №3 (Poppy) and Test №6 (Quesnelia), we found that all requests showed an improvement in performance, some requests improving by more than 10 seconds. Furthermore, during the same 1-hour test duration, Test №6 (Quesnelia) processed 26 more invoices and 12,580 more blank invoice lines compared to Test №3 (Poppy).
Test Runs
Test № | Date | Test Conditions | Results |
1 | Mar 30, 2024, 8:21 AM UTC | Test environment Poppy(ocp3), PO with PO Lines(10)+Invoice with PO lines(10 from Order) | Completed |
2 | Mar 30, 2024, 8:14 PM UTC | Test environment Poppy(ocp3), PO with PO Lines(500)+Invoice with PO lines(500 from Order) | Completed |
3 | Apr 2, 2024, 8:34 AM UTC | Test environment Poppy(ocp3), Invoice with blank invoice lines(500) | Completed |
4 | Apr 5, 2024, 11:04 AM UTC | Test environment Quesnelia(qcp1), PO with PO Lines(10)+Invoice with PO lines(10 from Order) | Completed |
5 | Apr 5, 2024, 2:03 PM UTC | Test environment Quesnelia(qcp1), PO with PO Lines(500)+Invoice with PO lines(500 from Order) | Completed |
6 | Apr 5, 2024, 4:00 PM UTC | Test environment Quesnelia(qcp1), Invoice with blank invoice line(500) | Completed |
Test Results
Test №1
Test environment Poppy(ocp3), PO with PO Lines(10)+Invoice with PO lines(10 from Order)
Requests |
| Response Time (seconds) | ||||
50th pct | 75th pct | 95th pct | 99th pct | Average | ||
|---|---|---|---|---|---|---|
IO_POST invoice/invoice_lines Create Invoice Line (POL) | 1128 | 0.883 | 0.964 | 1.648 | 1.984 | 0.976 |
IO_POST invoice/invoices Create Invoice | 113 | 0.103 | 0.121 | 0.162 | 0.179 | 0.1 |
POO_POST /orders/composite-orders Create Order | 113 | 0.159 | 0.201 | 0.286 | 0.769 | 0.179 |
POO_POST orders/order-lines Create Order Line | 1130 | 0.072 | 0.104 | 0.183 | 0.273 | 0.095 |
AIE_PUT invoice/invoices/[invoice_id] Pay Invoice | 111 | 2.477 | 2.733 | 2.89 | 3.162 | 2.375 |
AIE_PUT invoice/invoices/id | 111 | 1.311 | 1.473 | 2.064 | 2.846 | 1.391 |
POO_PUT orders/composite-orders/[order_id] Open Order | 113 | 3.07 | 3.927 | 4.443 | 4.684 | 3.002 |
PUT orders/composite-orders/[order_id] Approve Order | 113 | 0.178 | 0.258 | 0.86 | 1.236 | 0.254 |