Don’t select what you don’t need s very common that you need to get only a specific number of records from your database. For example, a blog which is showing ten entries per page. In that case, you should definitely use the LIMIT paramete Avoid queries in loops