Uploaded image for project: 'Nuxeo Studio'
  1. Nuxeo Studio
  2. NXS-1636

Update statistics less often

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.12
    • Component/s: None

      Description

      The hourly statistic is run using

      select nx_update_studio_stats()
      

      It takes 72s to execute and it generates important io activity.
      It also load a big portion of the nxp_logs into the shared buffers (25%) which interfere with other db actions.
      This needs to be improved.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: