Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-12190

Enable pagination in the measurements API endpoint to constraint queries

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      We need to constraint the query that loads the measurenents in the monitor, right now we are reading all measurements and it is slow, the ideia is to add a filter called window and a select widget place right above the plot showing:

      • Last 3 months
      • Last 6 months
      • Last year
      • All

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          afausti Angelo Fausti added a comment - - edited

          See time profiling for the following queries:

          http://localhost:8000/measurements/?ci_dataset=cfht&metric=AM1&period=3m (160ms)
          http://localhost:8000/measurements/?ci_dataset=cfht&metric=AM1&period=6m (215ms)
          http://localhost:8000/measurements/?ci_dataset=cfht&metric=AM1&period=1y (268ms)

          Show
          afausti Angelo Fausti added a comment - - edited See time profiling for the following queries: http://localhost:8000/measurements/?ci_dataset=cfht&metric=AM1&period=3m (160ms) http://localhost:8000/measurements/?ci_dataset=cfht&metric=AM1&period=6m (215ms) http://localhost:8000/measurements/?ci_dataset=cfht&metric=AM1&period=1y (268ms)
          Hide
          Permalink
          afausti Angelo Fausti added a comment -

          Code changes calculation are much faster now, with a single query we can basically retrieve all the information needed:

          http://localhost:8000/code_changes/?ci_dataset=cfht (~2s)
          http://localhost:8000/code_changes/?ci_dataset=hsc (~200ms)

          see attached queries for details.

          Show
          afausti Angelo Fausti added a comment - Code changes calculation are much faster now, with a single query we can basically retrieve all the information needed: http://localhost:8000/code_changes/?ci_dataset=cfht (~2s) http://localhost:8000/code_changes/?ci_dataset=hsc (~200ms) see attached queries for details.
          Hide
          Permalink
          afausti Angelo Fausti added a comment - - edited

          To improve comparison of the Metric measurements with the # of packages changed in the monitor app disable one of the y-axis for zoom/panning

          https://stackoverflow.com/questions/34085548/bokeh-two-y-axis-disable-one-axis-for-zoom-panning

          Show
          afausti Angelo Fausti added a comment - - edited To improve comparison of the Metric measurements with the # of packages changed in the monitor app disable one of the y-axis for zoom/panning https://stackoverflow.com/questions/34085548/bokeh-two-y-axis-disable-one-axis-for-zoom-panning

            People

            Assignee:
            afausti Angelo Fausti
            Reporter:
            afausti Angelo Fausti
            Watchers:
            Angelo Fausti
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Jenkins

                No builds found.