Versions Compared

Old Version 6

changes.mady.by.user Roman_Fedynyshyn

Saved on

compared with

New Version Current

changes.mady.by.user Roman_Fedynyshyn

Saved on

Key

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

Jira Legacy
serverSystem JiraJIRA
serverId01505d01-b853-3c2e-90f1-ee9b165564fc
keyPERF-143

...

Both tests shows almost same behaviour and passed without errors. DB CPU usage reach 100% due to high RPS rate. However there is a differences between usage of CPU in modules related to token cache. 

Moreover we found that on BHS1 is missing index 2020-12-09 17:45:10.097,"WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == abf9af79-4c57-4615-800f-bfa9303b6fa4 >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('abf9af79-4c57-4615-800f-bfa9303b6fa4'))"


Version:

mod-circulation:19.2.7;

...

mod-circulation-storage:12.1.4;


Tests:

Test #

Virtual Users

Duration (sec)

Env
1101800BHS1
2101800GCP1



Results comparison:

BHS1 test runruns

Requests Total
OK
Req/sResponse times (Seconds)
Min
50th pct75th pct95th pct
99th pctMax
BHS1GET /loan-storage/loans?(userId=={UserID} and status.name<>Closed)
106040
10604058.907
0.046
0.1620.1990.263
0.328
1.637
GCP1

...

RequestsTotalOKReq/sResponse times (Seconds)Min50th pct75th pct95th pct99th pctMaxGET /loan-storage/loans?(userId=={UserID} and status.name<>Closed)
109728
109728
60.9570.
0510.
1570.1910.250
0.3041.200

Delta

Response times (Seconds)
Min50th pct75th pct95th pct99th pctMax
-0,005-0,005-0,008-0,013-0,024-0,437


BHS1 Service CPU utilisation

...