Home MySQL LIMIT offset performance Evey so often we need to SELECT a bunch of rows by date, category or keyword and show the result paginated. Pagination is almost always an implicit requirement. After all we have limited screen space and there's only so much of information we can read and comprehend at once. There's no need to transfer more information than we are going to show. We need to defer