When we had only 20 000 records in the Five colleges tenant, lookups by Instance UUID where fast, both through the UI, the API and also through the database. Now, with 7.6 million records, the requests are timing out.
I made test loads with 20 000 records using the exact same process as with the 7.6 million, so I am pretty certain that it is the number of records that is the cause for this.
Throught the ui:
Through the API:
A request to baseUrl/source-storage/records/910890c8-3b58-4381-9ba8-725432ded07a?identifier=INSTANCE
gives me a HTTP 504 after 6minutes 40 seconds
Through the Database: