in reply to Inserting large chunks of data into MySQL

Vagueness aside, if this is a recurring need also consider reformatting your data into a format which the mysql bulk loader can handle (for instance CSV). That's more than likely going to run faster than any ad hoc DBI you whip up.

The cake is a lie.
The cake is a lie.
The cake is a lie.

  • Comment on Re: Inserting large chunks of data into MySQL