Database Optimize MySQL Queries By Using BETWEEN Instead of LIMIT and OFFSET Doli Stepniewski July 26, 2015 2 Comments Using BETWEEN instead of LIMIT and OFFSET proved to be a simple optimization to a troublesome slow MySQL query.