Do you know where your variables are? | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
But your code does not use DBIx::BulkLoader::MySql at all! You are using straight DBI.
The fastest option for your bulk loading is probably using the LOAD DATA INFILE statement from MySQL.That statement expect a file with the data and does a very fast insert into the database. You can use Perl to transform your data into a format expected by the LOAD DATA INFILE statement. CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James In reply to Re: Bulk data insertion into MySql
by CountZero
|
|