Hello
We are working on a project using PHP and Mysql database, at which time a large range of records (for example, between 5 thousand and 1 million) should be inserted in the database,
At the moment, the most basic way to get performance we found would be to do a single insert.
INSERT INTO clientes(id, nome, cpf, email, telefone)
VALUES (1, "Lorem Ipsum", "09941752727", "[email protected]", "1140028922"),
(1, "Lorem Ipsum", "09941752729", "[email protected]", "1140028922")...
The problem with this method is that it does not check if the record has already been entered previously and also does not allow us to check the progress of the insertion so that we can see on the screen how much is missing to complete.
Is there a way to solve these problems and still get high data insertion performance?