3.6.12. Optimise (Limit)
Limit
Valueable on sorts (0,10 faster than 0,1000!)
Beware limit referencing
Limit 1000,10 will fetch the first 1000, then give you the 10 you want
Search engines
Better to use WHERE restriction if possible