Status: Closed (View Workflow)
Default order by on paging APIs to an appropriate indexed field
NOTE: This is based on William Welling's analysis of SRS changes that would be helpful for initial data migration. Several other issues linked to the same feature as this one
When making requests for source records, records, or snapshots with limit and offset and order by is not provided, it should default to id or another appropriate indexed column. Otherwise, the results will be unpredictable. https://www.postgresql.org/docs/9.3/queries-limit.html
Possibly here, https://github.com/folio-org/mod-source-record-storage/blob/master/mod-source-record-storage-server/src/main/java/org/folio/dao/util/RecordDaoUtil.java#L488 for source records and records.
And here, https://github.com/folio-org/mod-source-record-storage/blob/master/mod-source-record-storage-server/src/main/java/org/folio/dao/util/SnapshotDaoUtil.java#L292 for snapshots.
UXPROD-2790 NFR: Make some revisions to Source Record Storage to improve performance for data migration