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.

Datenbankprogrammierung MySQL Perl

Projekt-ID: #10185235

Über das Projekt