AtlasOfLivingAustralia / ecodata

Data capture webservices supporting Biocollect and other apps
https://ecodata.ala.org.au/documentation/index
8 stars 15 forks source link

Record collection missing index on outputId. #923

Closed chrisala closed 4 months ago

chrisala commented 4 months ago

Unfortunately the activity save process queries records by outputId, even for activities not marked as creating records. Because MERIT reporting forms can have 30+ outputs in a single activity, the slow query adds up when executed that many times, resulting in a very slow save operation.