Uploaded image for project: 'mod-feesfines'
  1. mod-feesfines
  2. MODFEE-175

Performance issue with large dataset of fees/fines

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      EPAM-Veg Sprint 110, EPAM-Veg Sprint 111, EPAM-Veg Sprint 112, EPAM-Veg Sprint 114
    • Story Points:
      1
    • Development Team:
      Vega
    • Release:
      R2 2021
    • Affected Institution:
      University of Chicago

      Description

      A Honeysuckle user reports:

      I'm seeing performance issues with fees/fines in the Users app. Bringing up my own record, it took 8 seconds for the open fees page to move from showing a balance of zero with no fines, to listing the $1500+ in fines actually on the account. Is this a known performance issue?

      In my testing, performance was quite bad for feesfines and loans. The log for mod-feesfines reports:

      WARNING: Doing LIKE search without index for accounts.jsonb->>'userId', CQL >>> SQL: userId == 9ac59f38-d27a-4dd2-bb87-86759754d1a3 >>> lower(f_unaccent(accounts.jsonb->>'userId')) LIKE lower(f_unaccent('9ac59f38-d27a-4dd2-bb87-86759754d1a3'))
      Jan 20, 2021 9:31:17 PM org.folio.cql2pgjson.CQL2PgJSON queryByFt
      WARNING: Doing FT search without index for accounts.jsonb->'status'->>'name', CQL >>> SQL: status.name = Closed >>> get_tsvector(f_unaccent(accounts.jsonb->'status'->>'name')) @@ tsquery_phrase(f_unaccent('Closed'))
      

      as well as

      WARNING: Doing LIKE search without index for feefineactions.jsonb->>'userId', CQL >>> SQL: userId == 9ac59f38-d27a-4dd2-bb87-86759754d1a3 >>> lower(f_unaccent(feefineactions.jsonb->>'userId')) LIKE lower(f_unaccent('9ac59f38-d27a-4dd2-bb87-86759754d1a3'))
      

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                OleksandrVidinieiev Oleksandr Vidinieiev
                Reporter:
                wayne Wayne Schneider
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases