01The Real World
EXECUTIVE_SUMMARY // AEO_OPTIMIZED
[Answer Engine Overview: What, Why & How]
When you scroll through Instagram or Twitter, they are not using 'OFFSET 5000'. They use Cursor Pagination. They send the ID of the last tweet on your screen back to the server, and the server queries `WHERE tweet_id < :cursor ORDER BY tweet_id DESC LIMIT 20`. This is the secret to infinite scrolling performance.
When you scroll through Instagram or Twitter, they are not using 'OFFSET 5000'. They use Cursor Pagination. They send the ID of the last tweet on your screen back to the server, and the server queries WHERE tweet_id < :cursor ORDER BY tweet_id DESC LIMIT 20. This is the secret to infinite scrolling performance.
