Uploaded image for project: 'stripes-connect'
  1. stripes-connect
  2. STCON-44

Paging issues redundant requests

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • P2
    • Resolution: Duplicate
    • None
    • None
    • None
    • Vagrant build: 5.0.0-20171011.181
      PostgreSQL server: AWS RDS db.m4.xlarge

    Description

      We have a database of ~6 million items. On initial load of the items list, there are several, seemingly redundant, calls to /inventory/items:

      1st call (URL and the time to return for ~6million items):
      http://localhost:9130/inventory/items?limit=30&query=cql.allRecords%3D1%20sortby%20title - 1.2 minutes

      After the above completes, these 2 are called:
      http://localhost:9130/inventory/items?limit=30&query=cql.allRecords%3D1%20sortby%20title - 1.4 minutes
      http://localhost:9130/inventory/items?limit=30&query=cql.allRecords%3D1%20sortby%20title - 1.4 minutes

      After the above 2 calls return, these 3 are called:
      http://localhost:9130/inventory/items?limit=30&offset=30&query=cql.allRecords%3D1%20sortby%20title - 1.8 minutes
      http://localhost:9130/inventory/items?limit=30&offset=60&query=cql.allRecords%3D1%20sortby%20title - 2.0 minutes
      http://localhost:9130/inventory/items?limit=30&offset=30&query=cql.allRecords%3D1%20sortby%20title - 2.0 minutes

      Once all above calls complete the list loading animation (in the lower right corner of the list) disappears.

      As the user scrolls the list (assuming there is a use case for scrolling a list of 6 million items) many calls are again made to the backend:

      http://localhost:9130/inventory/items?limit=30&query=cql.allRecords%3D1%20sortby%20title
      http://localhost:9130/inventory/items?limit=30&offset=30&query=cql.allRecords%3D1%20sortby%20title
      http://localhost:9130/inventory/items?limit=30&offset=60&query=cql.allRecords%3D1%20sortby%20title
      http://localhost:9130/inventory/items?limit=30&offset=90&query=cql.allRecords%3D1%20sortby%20title
      http://localhost:9130/inventory/items?limit=30&offset=120&query=cql.allRecords%3D1%20sortby%20title

      Continued scrolling appears to issue all previous calls each time an additional 30 items are needed. This problem may not be specific to the items list, but any infinite scroll list.

      Can the UI only issue the request for data within a specific range once?

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                nielserik Niels Erik Gilvad Nielsen
                mreno Mathew Reno
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 1 hour
                    1h

                    TestRail: Runs

                      TestRail: Cases