Is the write speed normal?

Question

Python

Hello. There is a file with an array of test data (1 million elements: login, password, date of registration). Python reads a file and writes it to the database in 23 seconds. Is this a normal result? What good indicators are there when writing something like this to the database? Perhaps there are some features that will help speed up the process?

Answer 1

Perhaps there are some features that will help speed up the process

Writing all data to the database in one transaction, instead of a separate transaction to write each row of data.

Answer 2

Streaming reading of the file and distributed writing to the database is perhaps faster), but here you must either clearly divide the file into parts, or have a message broker. But for a one-time operation, this is an unnecessary complication.