✕ Clear all filters
2 articles
▶ Videos →

📰 Dev.to · hidetzu

2 articles · Updated every 3 hours · View all reads

All Articles 181,632Blog Posts 166,033Tech Tutorials 48,651Research Papers 35,704News 22,611 ⚡ AI Lessons
The Same Row Twice: Four Things Keyset Pagination Needs
Dev.to · hidetzu 2d ago
The Same Row Twice: Four Things Keyset Pagination Needs
Speed is OFFSET's second problem. The first is that page 2 can hand you a row you already read on...
Read article → + Playlist
OFFSET Doesn't Skip Rows: What 10M Rows in PostgreSQL Actually Cost
Dev.to · hidetzu 📊 Data Analytics & Business Intelligence 4d ago
OFFSET Doesn't Skip Rows: What 10M Rows in PostgreSQL Actually Cost
OFFSET 9999980 LIMIT 20 does not skip 9,999,980 rows. It reads every one of them, builds each tuple,...
Read article → + Playlist