Items table population is a single transaction doing 100000 inserts

[akanimesh7]

Context
MySQL version 8.0.30
Db Specs :-
db.m6i.large aws rds instance

While building the schema, i noticed that the population of items table takes a huge amount of time ~1.5 hours. On debugging the above i found out that this is a single transaction which is doing 100000 inserts into the items table at once. Hence this is very slow, on the other hand in other table populations such as stock the commits are happening at some intervals. Please let me know if this is deliberately done in this way. Also is there any way to make it quicker ?