Team lead gave me a task, fix a script he made to update 28k+ lines that wasn't working (he was busy with other stuff)

So I fixed and tested it in our dev environment, which had about 10 lines to use as test

Worked well, but a single select getting 1 column in a table is taking more than 40 secs, I need this select to run for every line (I tried making it get all data at once but it was getting duplicated entries)

The damn table doesn't have index, I think this will be the longest script I've ever made 😅😅😅