qwat / QWAT

TEKSI Water module (project QWAT) - QGIS project
https://www.teksi.ch
GNU General Public License v2.0
58 stars 31 forks source link

Load tests are required to validate trigger chain #150

Closed haubourg closed 8 years ago

haubourg commented 8 years ago

Tests will try to identify bottlenecks and deadlocks in database architecture.

First results shown on 13 september. Full results at PSC 06/10

haubourg commented 8 years ago

tests are published here : https://github.com/qwat/qwat-data-model/tree/19a25c22a11e0a607477d6871d7e9b05efae1a6d https://github.com/qwat/qwat-data-model/blob/19a25c22a11e0a607477d6871d7e9b05efae1a6d/tests/tests_scalability.sh

haubourg commented 8 years ago

Results are good, not performance issue. (See detailed report in share repository)

One deadlock has been found. Solution found by simplifyuing trigger cascade and removing valves from nodes