SELECT * FROM user LIMIT 10 OFFSET 200 ORDER BY user_id; This SQL query basically tells the database to "Skip the first 200 rows of the user table and get me the 10 rows that comes after that". If you want your database to get large without crashing your application, then you can't avoid query … Continue reading Why query pagination by OFFSET might be a bad idea →