Computations with a site_model.xml may become slow
Bug #1288262 reported by
Michele Simionato
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenQuake Engine |
Fix Released
|
High
|
Michele Simionato |
Bug Description
We saw in the case of Hannover RE Germany computation that the filtering was becoming very slow; the culprit is
the section:
s_sites = src.filter_
) if hc.maximum_distance else hc.site_collection
hc.site_collection is a property that in presence of a source model performs heavy queries on the db.
We saw on Wilson a load of 180 (!)
description: | updated |
Changed in oq-engine: | |
status: | In Progress → Fix Committed |
Changed in oq-engine: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
We can mitigate the problem by caching the site collection, so that the queries will be run only once per worker, not once per task. /github. com/gem/ oq-engine/ pull/1392
See https:/