[FOLIO-2110] Checking BugFest Q2.2 performance Created: 21/Jun/19  Updated: 03/Jun/20  Resolved: 24/Jun/19

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: Task Priority: P2
Reporter: Hongwei Ji Assignee: Hongwei Ji
Resolution: Done Votes: 0
Labels: platform-backlog
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Attachments: Text File bf22-slow.txt    
Issue links:
Relates
relates to MODFEE-10 Unclosed database transaction Closed
relates to FOLIO-2039 Research perf related tickets from Q2... Closed
relates to UIU-1086 Trailing space in search phrase trigg... Closed
relates to MODINVSTOR-292 Search instances by item.barcode is slow Closed
Sprint: CP: sprint 66
Story Points: 1
Development Team: Core: Platform

 Description   

Check to see if there are any new performance issues.



 Comments   
Comment by Hongwei Ji [ 21/Jun/19 ]

Found one new issue and created MODFEE-10 Closed

Comment by Hongwei Ji [ 24/Jun/19 ]

Summary: there are only 157 lines (see attached bf22-slow.txt) above 2 seconds threshold in Okapi log, so 2.2 is way better than 2.1 (157 vs 5816). All authtoken and perm queries related slow entries are gone after MODPERMS-59 Closed . Below is the breakdown of these 157 slow entries.

  • 42 mod-inventory
  • 42 mod-inventory-storage (same as mod-inventory since mod-inventory calls mod-inventory-storage)
  • 40 mod-users
    • 16 query users in multiple patron group (use = not ==). As in STCOM-492 Closed
    • 12 query that does not make sense (search user by a phrase and *). It turns out to be caused search phrase with trailing space. Opened UIU-1086 Closed
    • 10 query for all users /users?limit=2147483647 (under 3 seconds, not too bad)
    • 1 regular user search (~ 2 seconds)
    • 1 query by barcode /users?query=(barcode=="830") (~ 2 seconds)
  • 40 mod-kb-ebsco-java, RMAPI related
  • 4 mod-codex-ekb, RMAPI related
  • 1 mod-login-saml, /saml/configuration (2 seconds)
  • 1 mod-email, /email (2 seconds)
  • 1 mod-circulation, /requests (2 seconds)
  • 1 okapi, load ref/sample
  • 1 okapiClient, create permissions when enabling tenant
Generated at Thu Feb 08 23:18:16 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.