in reply to Implementing a buffered read-and-insert algorithm

Strongly suggest either LOAD DATA INFILE or some kind of bcp (Bulk Copy) program. Doing a zillion INSERTs is the slowest way to do this operation.

Alex / talexb / Toronto

"Groklaw is the open-source mentality applied to legal research" ~ Linus Torvalds

  • Comment on Re: Implementing a buffered read-and-insert algorithm

In Section Seekers of Perl Wisdom