Versions Compared

Version Old Version 16 New Version 17
Changes made by

Stanislav Nehrii

Stanislav Nehrii

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
outlinetrue

...

Test №

Date

Test Conditions

Results

1

12/20/24, 13:15 AM UTC

View Order history, View Order Line history and View Pieces history with 10, 50, 100 and 1000 changes on Data Set with 500k records

Completed
212/20/24, 13:11 AM UTC

View Order history, View Order Line history and View Pieces history with 10, 50, 100 and 1000 changes on Data Set with 1 million records

Completed
3

12/20/24, 15:45 PM UTC

View Order history, View Order Line history and View Pieces history with 10, 50, 100 and 1000 changes on Data Set with 5 million records

Completed

...

PO with PO Lines (1) + locations (5) + Change instance connection (Move holdings)



Transactions

Response Time (milliseconds)
Data size 500k


Data size 1 million


Data size 5 million


Averagepct90
pct95
pct99
Averagepct90
pct95pct99
Averagepct90
pct95pct99
TC_open order 10813
25132513
2513872
2526
2526
2526
894
2650
2650
2650
TC_open order 50446687
731735
453687
796800
469647
775775
TC_open order 100737
1343
1343
1343
7391346
13461346
8141722
17221722
TC_open order 1000670884
1149
657
1149657
858
10091009
680838
877880
TC_open order line 1013633159
31593159
1468
34643464
34641560
40834083
4083
TC_open order line 509131343
17121730
9251591
19101910
9361458
16261632
TC_open order line 10011811784
19811981
11701978
19961996
12352242
25662566
TC_open order line 100011971534
18191937
11921485
1635
1699
12131529
19762092
TC_open pieces 101268
2643
2643
2643
1249
26212621
26211269
26452645
2645
TC_open pieces 508801065
18711913
8811254
1475
1499
9151368
17291739
TC_open pieces 10011111844
1869
1869
11261531
15791668
11441811
18451845
TC_open pieces 10001062
12861426
1462
128611101305
16311803
10921489
16341639
TC_view order history 10541
1652
1652
1652
558
1613
1613
1613
544
13881388
1388
TC_view order history 50254383
474477
249314
384387
265380
537
537
TC_view order history 100477805
829
858
486886
886886
505849
856856
TC_view order history 1000452647
787787
445528
591
591
464681
775
968
TC_view order line history 107541610
16101610
738
15641564
15648231974
19741974788
TC_view order line history 50452619
816816449587629634489788
449587489788
TC_view order line history 1006951068
12741307
6771037
11321132
718
968
968
968
TC_view order line history 1000733900
973
988
760
12071207
1207746926
11511151
TC_view pieces history 10753
14331433
1433745
1422
1422
1422
7821801
18011801
TC_view pieces history 50452701
774783
449632
797869
454626
692695
TC_view pieces history 1006701008
1113
1133
6561086
11401140
7011081
11601160
TC_view pieces history 1000710945
945945
7011095
10951095
694862
906910




Transactions

Response Time (milliseconds)
Data size 500kData size 1 millionData size 5 millionData size 500kData size 1 millionData size 5 million
AverageAverageAveragepct90pct90pct90
GET audit-data/acquisition/order/[order_10]272834727489
GET audit-data/acquisition/order-line/[po_line_id_10]292729777090
GET audit-data/acquisition/piece/]pieces_10]/status-change-history282827646869
GET audit-data/acquisition/order/[order_50]181618584748
GET audit-data/acquisition/order-line/[po_line_id_50]2023405360344
GET audit-data/acquisition/piece/]pieces_50]/status-change-history172019445151
GET audit-data/acquisition/order/[order_100]222023625966
GET audit-data/acquisition/order-line/[po_line_id_100]272532656375
GET audit-data/acquisition/piece/]pieces_100]/status-change-history222123616260
GET audit-data/acquisition/order/[order_1000]4752481009881
GET audit-data/acquisition/order-line/[po_line_id_1000]122126132212231222
GET audit-data/acquisition/piece/]pieces_1000]/status-change-history60505311710596

...


table_nametable_sizeindexes_sizerow_count
cs00000int_mod_audit.acquisition_order_log2811 MB358 MB5300543
cs00000int_mod_audit.acquisition_order_line_log11 GB366 MB5400089
cs00000int_mod_audit.acquisition_piece_log3957 MB374 MB5220071


Comparison

Test №1-№2-№3

The following table compares the results between tests №1,  №2 and №3. 

  • Open Order: Response times increased nearly 10x in Test 3 compared to Test 1 due to the higher load (50 items per order).
  • Unopen Order: Similarly, response times grew approximately 4-5x in Test 3.

...

Here we can see that all modules show a stable trend.

Kafka metrics


OpenSearch Data Nodes metrics

...

PTF - environment Ramsons (rcon)

  • 10 m6g.2xlarge EC2 instances located in US East (N. Virginia)us-east-1 [Number of ECS instances, instance type, location region]

  • 1 instance of db.r6.xlarge database instance: Writer instance

  • OpenSearch

    • domain: ptf-test

    • Number of nodes: 7

    • Version: OpenSearch_2_13_R20240520-P5

  • MSK - fse-tenant

    • 4 kafka.m7g.xlarge brokers in 2 zones

    • Apache Kafka version 3.7.x

    • EBS storage volume per broker 300 GiB

    • auto.create.topics.enable=true

    • log.retention.minutes=480

    • default.replication.factor=3

...