I doubt that even the LOAD DATA INFILE statement will insert 10 lakh records in a few seconds.
in reply to Re^2: Bulk data insertion into MySql
in thread Bulk data insertion into MySql
As far as DBIx::BulkLoader::Mysql is concerned, did you try installing it through cpan?
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