Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-382

Improve performance and large data set handling of the Route Queue view

    Details

    • Similar issues:
      KULRICE-6724Override Spring class to improve startup performance
      KULRICE-7714Performance improvements in regards to workflow data access
      KULRICE-1130improve performance of xml ingestion
      KULRICE-6557Improve Performance and Memory Consumption
      KULRICE-13136Performance issues routing person maintenance document when user is a member of large roles
      KULRICE-12341Performance issues opening large roles
      KULRICE-269JSP Error in Route Queue View
      KULRICE-12540MultiValuePredicates do not handle large value sets appropriately
      KULRICE-8918Improved KRAD collections performance
      KULRICE-559Route Queue failing on startup
    • Rice Module:
      KSB, KEW

      Description

      When there are a lot of rows (10s of thousands which is possible in certain cases) in the EN_MESSAGE_QUE_T table, attempting to open the route queue view is very slow and can cause an OutOfMemoryError.

      I think this is because we select the entire set of queue rows into memory when we load the view. We need to constrain the set that gets loaded. We can do this by putting a throttle on the number of rows we select (similar to doc search) and/or we could implement custom paging/sorting using the display tag. Either way, we need to make sure we only select a reasonable number of rows from the queue table.

        Activity

        Hide
        Eric Westfall added a comment -

        I have fixed this so that the query contrains the rows returned to 1000.

        Show
        Eric Westfall added a comment - I have fixed this so that the query contrains the rows returned to 1000.

          People

          • Assignee:
            Eric Westfall
            Reporter:
            Eric Westfall
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Structure Helper Panel