Make a MySQL insert Perl script so it does batch insert

Avbrutt Lagt ut Apr 11, 2016 Betales ved levering
Avbrutt Betales ved levering

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.

Databaseprogrammerere MySQL Perl

Prosjekt-ID: #10185235

Om prosjektet

Eksternt prosjekt Aktiv Apr 11, 2016