Huge dataset, ORDER BY date and limit
===

I have a MySQL table with ~3.5mio lines. I want to iterate over each line. Since i do not want to load all 3.5mio lines, i split up the query seperating it into small ones. For the split i am using the date field.

The problem now is: When i select from the table with lines bigger than a specified date, it still looks after every date, puts them in a temporary list and than cuts of 90% of the entries since i only want small parts.

How can i create my query so that my computer does not crash it loads the whole table?