<p>That value on the user page is actually a special cache, not the real count.</p>
<p>Numbered pagination needs to go pretty much everywhere, precisely because it requires all the records to be counted to determine how many pages there are and then when page N is visited you have to read through all the records in order to find the right ones. That's why it gets noticeably slower the further down the list you go, and it's far worse when a search engine decides to visit all the pages...</p>
<p>The correct solution is to do pagination based on an indexed field (either the changeset ID or the timestamp in this case) so that viewing the hundredth page can be done by an indexed lookup. That is in fact exactly how this particular already works I believe, it just doesn't put that marker value in the URL at the moment.</p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly or <a href="https://github.com/openstreetmap/openstreetmap-website/issues/1089#issuecomment-210459018">view it on GitHub</a><img alt="" height="1" src="https://github.com/notifications/beacon/ABWnLUTYdxyH6-Hjdbz8mcxaY_t6lgfpks5p343WgaJpZM4GlHt9.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/openstreetmap/openstreetmap-website/issues/1089#issuecomment-210459018"></link>
<meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>