| Page Properties | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Context
Tracking
| Type | Ticket | Module | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Module ticket |
| mod-audit | ||||||||
| Arch ticket |
|
Technical details
The circulation log data is persisted in jsonb format in FOLIO database and itemBarcode field is part of the nested array items as each circulation log record can contain multiple items. No indexes are present for the table.
...
Circulation log search by item barcode slow when table contains millions of rows.
Stakeholders
Options
Option A - define retention policy (use archive or table partitioning)
...