DEV Community

Discussion on: The SQL I Love. Efficient pagination of a table with 100M records

databasesponge profile image
MetaDave 🇪🇺

... with 100 000 000 records, the query is never finished. The DBMS just kills it. Why? Probably, because it led to the attempt to load the whole table into RAM. Before returning data to the client.

But you don't mean that the database would not return data to the client application before it had finished reading the data, do you? You might like to clarify exactly which client you mean, here.