I believe this is a bit more complex than what it looks like
There is a lot of Mystery about Mysql and InnoDB and unlimited things to test to be honest I only see r397 as the only one who knows EXACTLY how things work around databases!
I found a post of r397 in another forum (I believe it is called SitePoint) from years back, and tried his solution, see what happened:
SELECT id FROM `products_table` LIMIT 200000 , 10
Showing rows 0 - 9 (~101 total, Query took 266.0895 sec)
Saying that, I am really curious to see what his explaination would be here. He surprises me sometimes.
SELECT id FROM `products_table` ORDER BY id LIMIT 200000 , 10
Showing rows 0 - 9 (~101 total, Query took 0.2475 sec)
When it comes to any OOP realted issues Northie is by far the best in Devshed.
Northie, infinite scrolling looks great, only if there was no JS involved.