@Ryan With nApi enabled, the script took two long hours to finish! Any ways to speed this up?

I run 100 promises concurrently everytime

so 1 million gets converted to 3 million

to give you a little bit context

in our Prisma 1 db, we saved insights like favorites and ignores in join tables, saving only ids of the user and the item

in our Prisma 2 db, we refactored the model

now we have a separate Insight table

it has an enum with multiple types

like ignores, ignores_unique, favorite, favorite_unique, etc

the old model didnt have createdAt, the new one does in addition to other info

so converting from old to new, I'm checking if the insight is there first, creating it if not then checking if it has the unique type of the same type, ignores? => check ignores_unique if not, I create a unique insight

and so on, and so forth

to check if an insight exists, I use a count query