Study area database INSERT is slow

smallAreaHealthStatisticsUnit / rapidInquiryFacility

The Rapid Inquiry Facility (RIF) helps epidemiologists and public health researchers in environmental health activities.

GNU Lesser General Public License v3.0

14 stars 5 forks source link

Open peterhambly opened 5 years ago

peterhambly commented 5 years ago

The Study area database INSERT in the middleware is slow, being responsible for the most time in study setup:

It is done one area at a time. It would be best to do an array insert; if not possible a multi-row INSERT by SELECT would do;
The trigger code is slow on Postgres and needs to be pruned to speed it up