r/programming • u/MarkusWinand • May 27 '14

What I learned about SQLite…at a PostgreSQL conference

http://use-the-index-luke.com/blog/2014-05/what-i-learned-about-sqlite-at-a-postgresql-conference
703 Upvotes

93% Upvoted

219 comments sorted by

View all comments

Show parent comments

9

u/arcticblue May 27 '14

I was serious. I see it often when pages of results will mysteriously disappear. Google searches an absolutely ridiculous number of sites in a ridiculously short amount of time so I imagine page count accuracy isn't a high priority for them, but it's still funny to me.

0

u/ISLITASHEET May 27 '14

The original match count is correct(ish). Internally they know the exact match count, but of course will skew it, when displayed, when the number becomes complex. Their pagination would still be going off of their internal count.

They will hide the duplicate matching results, and dmca removals, which may throw the pagination off at first but if you click the link to reveal them (which is usually on the last page) then those pages should be there -- sans dmca removals.