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

Enable hibernate second level cache for org.openmrs.Privilege

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed
    • Should
    • Resolution: Fixed
    • None
    • Platform 2.0.2, Core 2.1.0
    • None
    • None
    • 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

              preethi.s Preethi S
              preethi.s Preethi S
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: