使用分页处理大量的数据库条目会随着时间的推移而变慢

I am trying to process millions of records from my table (size is about 30 GB) and I am currently doing it using paging (mysql 5.1.36). The query I use in my for loop is I am trying to process millions of records from