2 ms·
From a technical perspective, in many cases getting the total count required for formal pagination is actually extremely tricky. Even in postgres, the count ope
by ralusek 8y ago
From a technical perspective, in many cases getting the total count required for formal pagination is actually extremely tricky. Even in postgres, the count operation on an indexed table is extremely slow. In cases where the query is doing something more complicated than hitting an RDBMS, getting the total count could be substantially more complicated.
Also, I hate pagination in almost every case.
- otterley 8y agoPagination doesn’t require a total page count to still be useful. You might remember Google’s UI in its first 10 years or so, which had pagination but not a total page count (if the number of pages exceeded 10 or so). You can use a ellipsis or a word like “many” and people will easily understand.
- anarazel 8y agoThese day they just estimate the size of the resultset. It's pretty easy to come up with queries where it estimates the wrong row count until you paginate to a later page. I think the theory is just that approximately nobody clicks on more than the third page. Example on first try: https://www.google.com/search?q=foobarfrak https://www.google.com/search?q=foobarfrak navigate to the last result. And you get a really misleading "No results containing all your search terms were found." page...