Optimization algorithm for batch data insertion by CI
$ Sub_form = array (); $ loop = 0; $ ins_loop = 0; $ sum = count ($ form_datas); $ this-> logger-> info ('Insert data total: '. $ sum); // using batch transaction import helps improve insertion efficiency $ callStartTime = microtime (true); $ this-> db-> trans_start (); foreach ($ form_datas as $ item) {$ loop ++; $ sub_form [] = $ item; if ($ loop % 200) = 0 | $ loop = $ sum) {$ this-> logger-> info ('Insert data num :'. $ loop); $ res = $ this-> kb_object_instance_mdl-> insert_batch ($ su B _form, $ obj_id); $ ins_loop ++; unset ($ sub_form); if ($ ins_loop % 5) = 0) {$ this-> logger-> info ('Insert data trans_complete ins_loop :'. $ ins_loop); $ this-> db-> trans_complete (); if ($ loop! = $ Sum) {$ this-> db-> trans_start () ;}}// $ this-> db-> trans_complete (); $ callEndTime = microtime (true); $ callTime = $ callEndTime-$ callStartTime; $ this-> logger-> info ('Insert data use time :'. sprintf ('%. 4f ', $ callTime); if ($ this-> db-> trans_status () === TRUE) {$ this-> _ show_msg ('1 ', array ('data' => 'import OK ');} else {$ this-> _ show_error ('saveorupdate error ');}