Make a MySQL insert Perl script so it does batch insert

I have a Perl MySQL CSV inserter script that is called from another CGI Perl script with system function. It now loops around a file input's array and inserts to the MySQL database using DBI module and outputs its progress to the browser.

I would like it made so that the script will batch insert like this reference URL: [url removed, login to view]

The attached files are the inserter script you need to modify, and the CSV file used as a test. I would like at least a 5x increase in performance by bulk inserting, but faster the better.

데이터베이스 프로그래밍 MySQL Perl

프로젝트 ID: #10185235

프로젝트 소개