App name/area of issue:
Establish performance baseline for Contains any, Contains all, Not contains any, Not contains all operators on the large data set.

Brief statement of the issue
https://folio-org.atlassian.net/browse/MODFQMMGR-130 and https://folio-org.atlassian.net/browse/MODFQMMGR-131 implemented the functionatlity on BE. Before the UI work is done, there is a need to determine how performant such searches are on the large (LC-like) data set.

Steps to recreate the issue:

Conduct search for each of the operators on the following data:

• Instance records:

  • Contributor types

  • Languages

  • Statistical codes

• Holdings records:

  • Statistical codes

• Item records:

  • Statistical codes

• Organizations - contact info

  • Organization aliases

  • Organization types

• Organizations - vendor info

  • Organization aliases

  • Organization types

• Purchase order lines

  • Acquisition units

  • Fund distribution codes

  • Fund distribution values

• Users

  • Departments

  • Address types

How many users at any given time:

1, 4, 8, 10 users

Volume of data:

• 22M instances

• 23M holdings

• 21M items

• 5000 organizations

• 10M PO Lines

Expected response time:
To be established

Main modules that are involved in the process (if obvious or if known):

• mod-fqm-manager

• mod-lists

• mod-inventory-storage (data only)

• mod-organizations-storage (data only)

• mod-circulation-storage (data only)

• mod-users (data only)

Interfaces required for UI:

entity-types 2.0 (provided by mod-fqm-manager)

fqm-query 2.0 (provided by mod-fqm-manager)

lists 1.0 (provided by mod-lists)

Interfaces required for BE services:

item-storage: 10.0
holdings-storage: 6.0 7.0
instance-storage: 10.0
instance-types: 2.0
loan-types: 2.2
material-types: 2.2
shelf-locations: 1.1
location-units: 2.0
locations: 3.0
call-number-types: 1.0
holdings-types: 1.0
service-points: 3.3
users: 16.0
user-tenants: 1.0
loan-policy-storage: 2.3
loan-storage: 7.1
organizations-storage.organizations: 3.3
organizations-storage.organization-types: 1.0
orders-storage.po-lines: 12.0
orders-storage.purchase-orders: 8.0
acquisitions-units-storage.units: 1.1
contributor-types: 2.0
contributor-name-types: 1.2
modes-of-issuance: 1.1
instance-statuses: 1.0
statistical-code-types: 1.0
statistical-codes: 1.0
configuration: 2.0
finance.exchange-rate: 1.0
circulation: 14.2
orders: 12.0
organizations.organizations: 1.2
voucher-storage.vouchers: 1.2
voucher-storage.voucher-lines: 2.1
voucher-storage.voucher-number: 1.1
login: 7.0
permissions: 5.3