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
-
customfield_11100 13869
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
- relates to
-
STCON-57 paging seems to be refetching all pages
-
- Closed
-