$array = Array( [a001] => Array( [0] => Array( [id] => 1789823 [start] => 2014-09-29 [end] => 2014-10-02 [status] => 1 ) ) )
function to insert reservation:
foreach ($array as $room_id => $item) { foreach ($item as $reservation) { db_insert('reservation')->fields( array( 'room_id' => $room_id, 'id' => $reservation['id'], 'start' => $reservation['start'], 'end' => $reservation['end'], 'status' => $reservation['status'] ) )->execute; } }
I have an multidimensional array $array
and it has about 30000 records of $reservation
index. Using looping method above in my personal computer, it takes about 30 minutes to insert all of reservation, my PC spec is (dual core, memory 2GB).
Is any better implementation to do insert job?