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

Enable hibernate second level cache for org.openmrs.Privilege

    XMLWordPrintable

    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

        Gliffy Diagrams

          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
              Reporter:
              preethi.s Preethi S
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: