Uploaded image for project: 'Kuali Rice Development'
  1. Kuali Rice Development
  2. KULRICE-382

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

    Details

    • 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.

        Attachments

          Activity

          Hide
          ewestfal Eric Westfall added a comment -

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

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

            People

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

              Dates

              • Created:
                Updated:
                Resolved: