On a related issue, see the discussion here: Upgrade from OJS 3.0.1-1 to 3.1.1 takes a long time (1hr+)
@asmecher I wonder if there is something that could be done with the sql’s that update the metrics table? With a 1 GB database it took 36 hours to complete and the single sql mentioned in the other thread took around 30 hours. Can not even imagine how long it takes when the database is 4 GB.
Instead of running a single sql, maybe it could be changed to a function that fires several smaller sql’s?