Bulk Data Import Database

1. The problem arises because one-time import says too much to cause

① time longer than 30s required modification configuration resolution ② because the disposable memory is too large also need to modify the configuration

I do not want to modify the configuration, so use the following method is TP5 INSERT statement

In short, the overall idea is divided into a convenient array of units (loops) into the SQL statement inserted every time n;

$ZW _box[]=[      ' zhiwei ' = $zhicheng [' Zhiwei '],      ' ygid ' + $zhicheng [' Ygid '],      ' Choubei ' =>$ zhicheng[' Choubei ',      ' Yuefen ' + date ("Y-m"),      ' djhf ' = ' wu ',  ' sjry ' = ' none ',  ' sanid ' = ' None ' ",  ' zzqk ' = $zhicheng [' Zzzt '],  ' Didian ' and ' Diqu ']];for ($i = 0; $i < Ceil (count ($zw _box)/ $i + +) {echo db::name (' Zw_dy ')->insertall (Array_slice ($zw _box, $i *100,100));}

Bulk Data Import Database