William Attwood wrote: > Ahh, I did it like this for the MySQL inserts - I had over 100mil > records to put into the MySQL DB; doing them 8000 at a time was much > faster than one at a time. True, there are faster ways to accomplish > this, however, I had PHP available on this server, and didn't want to > install un-needed software (it's bare bones MySQL with PHP for > Crons). This is just a ref. for those trying to also accomplish this > in PHP.
Gotcha. So the bulk insert is where the speed comes from, not the file processing. Does MySQL support transactions yet? Sounds like a great use for them. Start a transaction, add the queries one at a time, then post them in bulk (well, every 8000). /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
