Investigate the performance of the site_model queries in large examples
Bug #1372379 reported by
Michele Simionato
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| OpenQuake Engine |
Invalid
|
High
|
Michele Simionato | ||
Bug Description
We discovered that the site_model table was lacking a geospatial index, so that the performance was a bit worse than hazardlib doing a brute force computation.
Revision history for this message
| Michele Simionato (michele-simionato) wrote | #1 |
Revision history for this message
| Michele Simionato (michele-simionato) wrote | #2 |
| Changed in oq-engine: | |
| status: | New → Invalid |
| importance: | Undecided → High |
| milestone: | none → 1.4.0 |
| assignee: | nobody → Michele Simionato (michele-simionato) |
To post a comment you must log in.
A good model to study is the Saudi Arabia with 64,000+ sites. oq-lite could still be faster than the db-based solution.