Orders
A working search over every order, and a live count of what that costs. An equality filter on status is applied by the server with where. A text search still reads every page.
Waiting to read the orders…
Nothing fetched yet.
—
Status uses list with where, so the server returns only rows of that status. A text search has no contains match, so this page still reads every page of the list and filters in the browser. Sort happens here after the rows arrive.