PgTable with CQL2PgJSON, table, entityClass, collectionClass calls PgUtil

Description

See https://folio-org.atlassian.net/browse/MODPATBLK-178 how recreating CQL2PgJSON causes a performance issue.

Using PgUtil methods recreates CQL2PgJSON for every single request.

A new class PgTable should be provided that has a constructor that takes the table name, the entityClass, and the collectionClass.

Modules can create a static instance of PgTable.

PgTable creates CQL2PgJSON once and reuses it.

PgTable has the same public methods as PgUtil but without the table, entityClass and collectionClass parameters.

Environment

None

Potential Workaround

None

Checklist

hide

Activity

Show:

Khalilah GambrellMay 1, 2024 at 1:04 PM

Hey and - should this issue be assigned to the Poppy CSP #5 release?

cc:

Details

Assignee

Reporter

Priority

Development Team

Core: Platform

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created April 22, 2024 at 3:27 PM
Updated January 6, 2025 at 5:01 PM
TestRail: Cases
TestRail: Runs