Overview

Date: 27.05.2021

Objective: Weekly space for deep dive topics

Participants: (kindly only add your own names, not of other participants)

• Uwe Wahser

• Purushottam Sapkota

• Dragos Dobre

• Patrick Delcroix

Topic Proposals:

• Database performance

• Stored procedures

Presentations / Attachments

Minutes

Database performance

• background: performance issues in Nepal after legacy migration

• fix: downgrade to MS SQL 2014 or 2012

  • https://docs.microsoft.com/en-us/troubleshoot/sql/performance/upgrade-compatibility-level-degrades-performance

  • https://www.sqlskills.com/blogs/glenn/database-compatibility-level-in-sql-server/

• JSON field is still working with compatibility level 2014?

• JSON fields will be better handled in PostgreSQL, but need to do early test on large volumes

Stored procedures

• List to be provided

Mutations vs Service

Mutation : GraphQL way to push changes (include formating of the API calls)

Service: Generic python code to process openimis object

Most of the modular code use service for business process

Questions - Challenges - Issues

Next meeting (03.06.2021):

• DHIS2 Dashboards

• Beyond Health

• Accounting / Payment layer

Additional Resources