Welcome Guest, Not a member yet? Register   Sign In
How to insert thousands of entrys in MySQL
#3
Thumbs Up 

Thank you Badger!
It was exactly what I needed!
Following your instructions I solved my problem through insertBatch from Query Builder Class. It can see my code below.

PHP Code:
  $this->db->transStart();
    $csvTotal array_chunk($csvArr500);
                
    
foreach($csvTotal as $csvPartial){
      $this->insertBatch($csvPartial);
    }
                
  $this
->db->transComplete(); 

Thanks again!
Reply


Messages In This Thread
RE: How to insert thousands of entrys in MySQL - by Rafael.RM - 05-16-2022, 05:54 PM



Theme © iAndrew 2016 - Forum software by © MyBB