Advertisement
eyuprog

Insert Batch Chunk

Oct 19th, 2020 (edited)
1,962
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.50 KB | None | 0 0
  1. #Insert Batch secara default nya dilimit 1000 line
  2. #INSERT INTO table VALUE (field_1,field_2),(field_1,field_2)
  3. #Jika jumlah data lebih dari 1000 maka bisa menggunakan chunk. Contoh sebagai berikut
  4.  
  5. #Jadikan semua ke array
  6. $insert_batch=[];
  7. foreach($data_loop as $dl)
  8. {
  9.    $insert_batch[]=[
  10.     'name'=>$dl->name,
  11.     'bod'=>$dl->bod
  12.    ];
  13. }
  14.  
  15. #Insert batch per chunk 1000. Boleh berapapun, sesuai kondisi RAM
  16. foreach(array_chunk($insert_batch,1000) as $chk)
  17. {
  18.    DB::table('table')->insert($chk);
  19. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement