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

Enable pagination in the measurements API endpoint to constraint queries

    XMLWordPrintable

Details

    • Story
    • Status: Done
    • Resolution: Done
    • None
    • None
    • 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

          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)

          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.

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

          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

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

            Dates

              Created:
              Updated:
              Resolved:

              Jenkins

                No builds found.