Details

    • Type: Sub Task Sub Task
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.1, KFS Release 3.0
    • Fix Version/s: 1.0.1.1, KFS Release 3.0.1
    • Component/s: Development
    • Labels:
      None
    • Similar issues:
      KULRICE-10288Convert KEW UserOption table to JPA
      KULRICE-3752Responsibility objects are being queried from the database too often
      KULRICE-3735KIM Permission templates are queried from the DB too often
      KULRICE-6622"Packet too large" error thrown from inserting into Session document table
      KULRICE-6916KRIM_ENTITY_CACHE_T.PRSN_NM is too small
      KULRICE-10283Convert KEW Searchable Attribute tables to JPA
      KULRICE-10285Convert KEW Action List tables to JPA
      KULRICE-12201Collection Group With Refresh has way too many rows
      KULRICE-7945Implement Referential Integrity on KEW database tables
      KULRICE-2337Create group service plugin for KEW
    • Rice Module:
      KEW
    • Application Requirement:
      Rice

      Description

      Now that some of the other query hogs are out of the way, this one appears. The user options table is queried more than any other. Over 600 times during the creation and approval of a ProjectCode maintenance document.

      All the PK retrievals could be replaced with a single query and iterating over the results.

      For some reason, the system is often saving all of them (usually right after retrieving them) even though nothing has changed.

      I think there is supposed to be a cache in there for these, but it doesn't seem to be used.

        Activity

        Hide
        Jonathan Keller added a comment -

        OK - I've gotten rid of about 400 of the queries to that table with a small logic change in the preferences service. But there still seems to be something going on when back door is used where the preferences are saved on every request.

        Show
        Jonathan Keller added a comment - OK - I've gotten rid of about 400 of the queries to that table with a small logic change in the preferences service. But there still seems to be something going on when back door is used where the preferences are saved on every request.
        Hide
        Jonathan Keller added a comment -

        Found it. It was the USE_OUT_BOX option, which was not being saved unless that feature was turned on, causing the preferences to save every time the savePreferences method was called.

        Show
        Jonathan Keller added a comment - Found it. It was the USE_OUT_BOX option, which was not being saved unless that feature was turned on, causing the preferences to save every time the savePreferences method was called.
        Hide
        Jonathan Keller added a comment -

        I just checked the results - The number of PK retrievals on the user options table dropped from 666 (yes that was the number I got - on multiple runs) to 6

        Show
        Jonathan Keller added a comment - I just checked the results - The number of PK retrievals on the user options table dropped from 666 (yes that was the number I got - on multiple runs) to 6

          People

          • Assignee:
            Jonathan Keller
            Reporter:
            Jonathan Keller
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Structure Helper Panel