in reply to Re^2: How can i modify this code by using Bulk Loader?
in thread How can i modify this code by using Bulk Loader?

It is also a generic term for programs like mysqldump/mysqlimport, which can be used for this purpose :)

sowraaj needs to explain what he is talking about, even if we guess right sometimes

site:perlmonks.org LOAD DATA INFILE
trying to execute "LOAD DATA INFILE" using DBI::Mysql
  • Comment on Re^3: How can i modify this code by using Bulk Loader?

Replies are listed 'Best First'.
Re^4: How can i modify this code by using Bulk Loader?
by sowraaj (Novice) on Sep 02, 2011 at 13:51 UTC

    Dear friend,

    I can't hear these term (mysqldump/mysqlimport) but i need to make this code run faster. I use log file.txt file data which i used for parsing

    Thanks for your quick reply

      Maybe now is the time to learn about MySQL, and the tools available? Talk to your database administrator about what tools are available and how they can be used. This is not a MySQL support forum.

        Hi friend,

        I need to change this code by 'use DBIx::BulkLoader::MySql' or some other ways to insert 5000Rows/execution or some other ways

        Thanks for your quick reply