Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Inserting large chunks of data into MySQL

by Fletch (Bishop)
on May 04, 2008 at 15:19 UTC ( [id://684439]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://684439]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others taking refuge in the Monastery: (2)
As of 2024-06-23 21:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuli‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.