Brian Hurt wrote:
>
> Take, for example, inserting large numbers of records into a table. As
> someone who was raised on Postgres (so to speak), when loading large
> numbers (more than 10 or so) records into a table I immediate start
> reaching for a copy command. And our code base is littered with copies-
> from simple programs that given a CSV file and a table name burst-load a
> table, to complicated libraries that use multithreaded queues and switch
> between copies and transactional inserts depending upon how much data
> needs to be copied. But someone used to MySQL would just start firing
> off lone, non-transactional insert statements, and their code base
> wouldn't contain such programs or libraries.
Just to make sure that nobody gets confused here. MySQL has LODA DATA
INFILE as their COPY alternative, which performs marvelously.
regards,
Lukas