Only thing worse than pagination is infinite scrolling.
Only thing worse than pagination is infinite scrolling.
In the case of Twitter, ctrl-f would allow me to search through my bookmarks, my feed or the replies of the tweet I am looking at. Can the Twitter search do these things? If it can, it's really not obvious, and if not, that sucks because a lot of usability is going out the window with no replacement.
We could make very, very long scrolls of text in real life, but books are more practical.
Similar thing here, not everyone uses "Ctrl-F". Heck, many users don't know how to search (try to ask non technical people, you'd be surprised) and on mobile browsers for example, frequently there's no way to search (or no easy/easily discoverable way to search).
Infinite scrolling is crap, but 10K rows in a result is going to feel a lot like infinite scroll.
When the user add filters on columns or sets sort order it's added in the where or order by clause respectively of the outer query.
This way we can easily show 100k+ rows (like, all their invoices or orders), the user can scroll and filter to their delight etc, all super-responsive.
Surely it shouldn't be much harder to support on the web if one wanted?
I actually use a UI like that, and this particular one is not fun to use. You have to wait 2-3 seconds and experience unresponsive UI untill all the 10k rows are loaded
Having said that, I think this approach ("put about 10k rows into the browser") could still work, it just needs more love.
Part of the problem is the lack of filtering (or even sorting) on the client side to reduce the information overload to something you're willing to wade through, which would trade off results returned for query complexity (of course, this also assumes its been programmed correctly...).
We lose a lot using the 'search box only' query interface that google popularised.
If there is filtering, sometimes you can see how poor the integrity and/or quality of the data is due to some weird-ass categorisations, typing mistakes etc. etc.
Attempting to limit searches on laptops to a specific screen resolution did my head in on pretty much all of the major manufacturers sites.
Also, with smaller pages, site owners can track whether many users need page 2, 3, etc. and change page size or reload the next page’s data accordingly.
The initial query of all rows might be slow, but once I have a snapshot speed is not the issue. I regularly do ctrl+a ctrl+c alt+tab to Excel and ctrl+j to run a program that gives me the result I am looking for.
Where I have control over the back-end, I like to provide static dated snapshots of queries.
I can be stingy but I would look at: Time to run the query vs. Value of having all the data.
100-1000 elements for example could be accommodated on the same page. 10k make me think about data grids which may be improved by filtering on multiple columns for example.
EDIT: Guess you guys have no humor on this page