如何提高CSV上传的执行速度

我想知道你们中是否有人尝试过以实时形式(multipart/form-data)进行CSV迁移，我的是工作的，我唯一讨厌的是它消耗了太多的时间，并且达到了最大的执行超时。我所做的快速修复是通过在我的php.ini(或set_time_limit())中设置最大执行时间，但它真的很烦人，等待半个小时只是为了导入整个数据，虽然它不超过100kb。是我反应过度还是怎么的?

这是代码:

function upload($id, $old_eid)
{
    $filename = $_FILES['event_file']['tmp_name'];
    $handle = fopen($filename, "r");
    while(($data = fgetcsv($handle, 1000, ",")) !== FALSE){
        $id  = $id;
        $id2 = $data[2];
        $ckr = $this->Manager_model->check_if_record_exists($id, $id2);
        if(count($ckr) > 0):
            $this->session->set_flashdata('err', '<div class="error">Duplicated record</div>');
            redirect("manager/csver/$id");
        else:
            $data['col1'] = $data[0];
            $data['col2']  = $id;
            $data['col3'] = $data[3].' '.$data[4];
            $data['col4']  = $data[2];
            $data['col5'] = $data[6];
            $data['col6']  = $data[1];
            $data['col7']  = $data[7];
            $data['col8']  = mt_rand(11111, 99999);
            $data['col9']   = $old_eid;
            $this->Manager_model->add_csv($data);
            $this->Manager_model->add_csv_to_photo($data);
        endif;
    }
        fclose($handle);
        $this->session->set_flashdata('success', '<div class="success">CSV successfully uploaded</div>');
        redirect("manager/records/$id");
        //$this->session->set_flashdata('msg', '<div class="success">Records successfully uploaded</div>');
} 

:

 function add_csv($data)
{
    $src = array(
            'col1'=> $data['col1'],
            'col2'    => $data['col2'],
        'col3' => $data['col3'],
        'col4'  => $data['col4'],
        'col5' => $data['col5'],
        'col6'  => $data['col6'],
        'col7' => $data['col7'],
        'col8' => $data['col8'],
    );
    $this->db->insert('e_records2', $src);
    if($this->db->affected_rows() == '1'):
        return TRUE;
    endif;
    return FALSE;
}
function add_csv_to_photo($data) {
    $src = array(
            'col1'=> $data['col1'],
               'col2' => $data['col2'],
                'col3' => $data['col3'],
                'col4' => $data['col4'],
                'col5'=> $data['col5'],
                'col6'=> $data['col6'],
    );
    $this->db->insert('e_records', $src);
    if($this->db->affected_rows() == '1'):
        return TRUE;
    endif;
    return FALSE;
} function check_if_record_exists($id, $id2) 
{
    $eid = $id;
    $id2 = $id2;
    $query = $this->db->query("select * from races_results where eid = $eid AND id2 = $id2");
    return $query->result();
}

注:我这里讲的不是PhpMyAdmin因为我知道如何导入csv文件。此外，它还会创建许多琐碎的任务来使用骨骼来迁移文件。