Uploaded image for project: 'HTML Form Entry Module'
  1. HTML Form Entry Module
  2. HTML-143

provider list is too slow to load

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: TBD
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: HTML Form Entry 1.7.2
    • Labels:
      None
    • Complexity:
      Medium

      Description

      This is related to TRUNK-2041. getUserByRole is a painfully slow method. I'm checking in a changeset that creates a PersonStubWidget, that uses a hibernate SQL query to load providers by role. The difference that this gave me was for a db with 1470 providers, it took 120 milliseconds to load all provider stubs (per yourkit), and 20 ms to load a providerStub list by role where there were 4 providers who had a that particular role (also per yourkit). This is clearly a good improvement, and is especially good in the htmlformflowsheet context, where multiple htmlformentrysessions are being initiated at the same time.

        Attachments

          Activity

            People

            Assignee:
            dthomas Dave Thomas
            Reporter:
            dthomas Dave Thomas
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: