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

Paging issues redundant requests

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: P2
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Environment:

      Vagrant build: 5.0.0-20171011.181
      PostgreSQL server: AWS RDS db.m4.xlarge

    • Template:

      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

                Assignee:
                nielserik Niels Erik Gilvad Nielsen
                Reporter:
                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