You don't say what database access library you're using, but my guess is that the underlying query may have a 50 record buffer. I use Devart IBDAC and it has a 25 record buffer - setting the query property FetchAll to true results in all records being returned. Could something similar be happening here, with the iteration only running over the retrieved records?