msupply-foundation / open-msupply

Open mSupply represents our most recent advancement in the Logistics Management Information System (LMIS), expanding on more than two decades of development inherited from the well-established legacy of the original mSupply.
https://msupply.foundation/open-msupply/
GNU Affero General Public License v3.0
19 stars 12 forks source link

Investigate potential database performance bottlenecks #4266

Open andreievg opened 1 week ago

andreievg commented 1 week ago

This issue is place to list any performance concerns for the databases. This way we can be targeted with testing, set appropriate benchmarks, etc..

Inserts on sync buffer may become slow because it's indexed and growing (especially on central server)

[Inserts on change log may becomes slow] because indexed and growing (even more so the sync buffer)

Locking change log -> for central server when dealing with lots of simultaneous sync requests (updates and queries)

Add more here..

Needs discussion about how we conduct tests to validate theses concerns

andreievg commented 5 days ago

Triage, just taking off the needs triage, and will wait when we have time to refine. Keeping issue open so that we have a place to add other database areas that may need to be performance tested