All You Need Is Backend personal blog

Efficient pagination of a SQL table with 100M records

allyouneedisbackend.com published 2017-09-247 min read

Compilation of my favorite SQL queries after a decade of dealing with relational databases. Today we talk about scanning a table with 100 million records.

Points

248

HN comments

73

Submissions

1

Cited by

0 commenters

Databases & DataSoftware Engineering2017

Related posts from the same era

Apple open-sources FoundationDB

FFoundationDB Blog20182,136 points441 comments details

RethinkDB is shutting down

RethinkDB Blog20161,674 points441 commentscited by 9 details

Announcing SQL Server on Linux

Microsoft Blog20161,344 points476 commentscited by 5 details

Why we lost Uber as a user

PostgreSQL20161,234 points285 comments details

Congress votes to make open government data the default in the United States

E Pluribus Unum20181,130 points154 comments details

Introducing Cloud Spanner, a Global Database Service

Google Cloud Blog20171,068 points434 comments details