Strange, select jsonb from fs00001006_mod_source_record_storage.source_records_view limit 100 is pretty fast: 24783.129 ms, but baseUrl/source-storage/sourceRecords?limit=1 is timing out.
I discovered this when trying to harvest records over /oai/records?verb=ListRecords&metadataPrefix=marc21&set=all. That request is making requests to /source-storage/sourceRecords
Steps to reproduce:
Add the below mentioned amount of records to srs
Make a GET request to /source-storage/sourceRecords
What should happen:
Records are returned.
What actually happens:
Request times out after 6minutes and 40 seconds
In the FC and Alabama tenants there are about 7.6 and 5.5 million SRS records.
Using the same mapping and loading process, i loaded only 20k of records, and with that ammount, everything worked fine.
Module version: mod-oai-pmh-1.1.0
When we query the database, hitting the tables is pretty fast. The issues seem to occur when querying the view.