Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-4949

Patient Merge - HibernatePatientDAO - getDuplicatePatientsByAttributes - Not performing on large database

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Should
    • Resolution: Fixed
    • Affects Version/s: Platform 1.12.0
    • Fix Version/s: Platform 2.0.1, Core 2.1.0
    • Component/s: None
    • Labels:
      None
    • Complexity:
      Medium

      Description

      In one of the Bahmni implementations where we have relatively large DB of patients, approximately 175,000 patients, when user tries to search for duplicate patients based on Birth Date, Gender, Family Name and Given Name, the query times out. And if user keeps performing the same operation repeatedly then Java runs out of memory and even deadlock is created on some occasions. This leads to OpenMRS service to be restarted. And there is no way for the user to proceed with the patient merging.
      Currently the search for duplicates on Gender, DOB, Family Name and Given Name times out. After the fix it takes approximately 50-55 seconds to search for duplicates based on this criteria in DB with 175000 patients.

        Gliffy Diagrams

          Attachments

            Attachments-Category-Modification

              Activity

                People

                • Assignee:
                  karrtikiyer Karrtik Iyer
                  Reporter:
                  karrtikiyer Karrtik Iyer
                  Watchers:
                  Daniel Kayiwa, Darius Jazayeri, Karrtik Iyer
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: