3 ms·
Infinite scrolling fits SQL. Remember that LIMIT is considered harmful and is actually not part of the SQL standard.
by lowry 10y ago
Infinite scrolling fits SQL. Remember that LIMIT is considered harmful and is actually not part of the SQL standard.
- Hurtak 10y agoWhy is it considered harmful, what are the alternatives?
- lowry 10y agoBecause the table can change. Imagine showing the first 0..10 rows, deleting the 5th row, then showing 11..20 rows. And what happens if you insert rows while paginating? Iterators aka cursors are the other option.
- deleted 10y ago[deleted]