fgetcsv() ถ้าเป็นไฟล์ขนาดใหญ่จะทำงัยคับ รบกวนผู้รู้หน่อยคับผม

    private function importDataAmazonCsv($tempfile, $tableid) {
        $handle = fopen($tempfile, 'rb');
        echo $fsize = filesize($tempfile);
        $i = 0;
        $newfileSize = $fsize * 1024;
        $tmpsql = $this->setSqlAction($tableid);
        while (!feof($handle)) {
            while (($fileop = fgetcsv($handle, $newfileSize, ',')) !== false) {
                $query = $this->link->prepare($tmpsql);
                $tmpfileop = count($fileop);
                $num = 0;
                $tmpvalue = array();
                while ($num <= ($tmpfileop - 1)) {
                    array_push($tmpvalue, $fileop[$num]);
                    $num++;
                }
                if ($i != 0)
                    $query->execute($tmpvalue);
                $i++;
            }
        }
    }

private function importDataAmazonCsv($tempfile, $tableid) {
        $handle = fopen($tempfile, 'rb');
        echo $fsize = filesize($tempfile);
        $i = 0;
        $newfileSize = $fsize * 1024;
        $tmpsql = $this->setSqlAction($tableid);
        while (!feof($handle)) {
            while (($fileop = fgetcsv($handle, $newfileSize, ',')) !== false) {
                $query = $this->link->prepare($tmpsql);
                $tmpfileop = count($fileop);
                $num = 0;
                $tmpvalue = array();
                while ($num <= ($tmpfileop - 1)) {
                    array_push($tmpvalue, $fileop[$num]);
                    $num++;
                }
                if ($i != 0)
                    $query->execute($tmpvalue);
                $i++;
            }
        }
    }

private function setSqlAction($tablename) {// gen SQL
                $sql = "";
                $sql.="INSERT INTO $tablename (";
                $tmpField = $this->getFieldName($tablename);
                $sql.=implode(',', $tmpField);
                $sql.=") VALUES(";
                $v = count(explode(",", $sql));
                for ($i = 0; $i < $v; $i++) {
                    $sql.= "?,";
                }
                $tmp = $sql;
                $tmp = substr(substr($tmp, 0), 0, -1);
                $sql = $tmp;
                $sql.=")";
                return $sql;
 
}

private function getFieldName($table) {
        $query = $this->link->prepare("DESCRIBE $table");
        $query->execute();
        $table_fields = $query->fetchAll(PDO::FETCH_COLUMN);
        return $table_fields;
}