database - How to persist multiple entities as fast as i can Symfony 5

Question

i'm trying to add xlsx data to my data base as entities i wrote this script

$batchCount = 10000;
$i = 0;
foreach($rows as $row) {
                if (is_numeric($row[0])){
                    $i++;
                    $cart = new Carte();
                    //doing something
                    $this->em->persist($cart);
                    if (($i % $batchCount) == 0) {
                        $this->em->flush();
                        $this->em->clear();
                   }
                }
            }

But for a adding 50,000 line in database its taking to long I'd love if some one have fast method to add large data to database using Symfony

question from:https://stackoverflow.com/questions/65919964/how-to-persist-multiple-entities-as-fast-as-i-can-symfony-5

Answer 1

Waitting for answers