Bulk insert

Hi, pll

I am using DBI to insert and update a lot of records on a mysql database
(more than 300 000). I am not an experienced database user, but I think
there must be something I can do so I can do all these operations on
less time than the 12 hours it is taking :-|

I've talked with a friend and he says that normally databases has one
option: bulk insert/update. I can't find anything similar on MySQL.
Another option which can work, is to turn off indexes and keys on the
tables, but I do not know how to do that programatically by perl.

Can anybody help me with this?
Thanks,
Kind regards,
Alberto

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org