So what do you plan on doing with the other 4500 records? And doesn't this cause a backlog? You return 500 records on day 1 and then 4500 get pushed back to day 2. Then on day 2 you have 5000 more, process 500 and now you have 9000 backlogged records.

If all you seek is to use 500 records and don't care about the other 4500, just use