On Sat, 1999-08-14 12:26:34 -0700, Thimble Smith wrote:
> >"INSERT INTO a VALUES (record1),(record2),...,(record200)."
> In this case, the INSERT is a single operation, even though you are
> inserting many rows. This is the fastest way to insert values into
> a table.
In a first test with 10000 records (INT, INT, CHAR(16), DATETIME),
LOAD DATA LOCAL INFILE was about a factor of 3.5 faster (due to
reduced parsing overhead?).
But I don't know if this is a general rule ...
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7