Runs in about 20seconds on 2.1million rows

then

Now the code runs in over a minute

You're annoyed at this speed on 2.1million rows? Really? Are you sure?
as for serious advice, maybe you could store your data in a database, and access it through DBI? then you could run your transforms through an insert or update statement