When the use of a command-line or other tool is (for whatever reason) infeasible,
bulk-insertion operations are categorically improved through the judicious use of three techniques:
Table locking, or the use of transactions with a very strict “isolation level,” to preclude any conflicting operations by other users... or even access by other users.
Transactions, in general, to permit the database system to do “lazy writes” while carrying out the operation. The transaction is periodically committed and reopened so that the rollback-file does not become huge.
Disabling index updates and referential integrity checks until the entire operation is finished.
There is a very-considerable amount of material on this subject on the Internet, and you need not be concerned if the article you read is not specifically talking about Perl. The core concepts are universal.