Recently the Bahmni team debugged slowness issues at a client site, and were able to investigate the slowness due to specific SQL queries being slow. Creating a DB Index fixed the issue and resulted in dramatic improvement of CPU responsiveness and sync times.
Read the report writeup by Riya Kumari, Sweety, @mohant here: https://bahmni.atlassian.net/wiki/spaces/BAH/pages/3259335448/Troubleshooting+OpenERP+slowness+OpenELIS+failed+events+in+Bahmni
This can help in debugging DB slowness issues to folks using Bahmni.