Why does MYSQL higher LIMIT offset slow the query down?
I had the exact same problem myself. Given the fact that you want to collect a large amount of this data and not a specific set of 30 you’ll be probably running a loop and incrementing the offset by 30. So what you can do instead is: Hold the last id of a set of … Read more