query Archives | hello techo

Optimize MySQL Queries By Using BETWEEN Instead of LIMIT and OFFSET

Using BETWEEN instead of LIMIT and OFFSET proved to be a simple optimization to a troublesome slow MySQL query.

ERROR: Subquery returns more than 1 row Error Code: 1242 The "Subquery returns more than 1 row" error may indicate that your data is not