List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 15 1999 12:59am
Subject:Re: lock table speed up DB access?
View as plain text  
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 ...

Regards,
  Martin
-- 
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
Thread
questionsAnonymous14 Aug
  • Re: questionsMartin Ramsch14 Aug
  • RE: lock table speed up DB access?Ee Loon14 Aug
    • Re: lock table speed up DB access?Thimble Smith14 Aug
      • Re: lock table speed up DB access?Martin Ramsch15 Aug
        • Re: lock table speed up DB access?Michael Widenius21 Aug
    • Re: lock table speed up DB access?Sasha Pachev15 Aug