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

Enable hibernate second level cache for org.openmrs.Privilege

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Should
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Platform 2.0.2, Core 2.1.0
    • Component/s: None
    • Labels:
      None
    • Complexity:
      Low

      Description

      With the normal Bahmni workload, we have found that 'mysql privilege select' takes larger share in the total number of database hits.

      We ran a same set of gatling tests before and after adding ehcache for privilege and found that the average response time has reduced and throughput has increased thrice. Below are the images:
      Before cache:

      After cache:

      We propose adding Privilege to the Hibernate second level cache to see the above performance improvement. Also we would like this to be ported back to 2.0.x

        Attachments

        1. after_cache.jpg
          after_cache.jpg
          40 kB
        2. before_cache.jpg
          before_cache.jpg
          42 kB
        3. no_of_privilege_calls.jpg
          no_of_privilege_calls.jpg
          134 kB

          Activity

            People

            • Assignee:
              preethi.s Preethi S [X] (Inactive)
              Reporter:
              preethi.s Preethi S [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: