Thanks Sinisa for your reply,
Interesting alterative.
I tried:
a) ALTER TABLE foo DROP PRIMARY KEY
b) LOAD DATA INFILE file INTO TABLE foo
c) ALTER TABLE foo ADD PRIMARY KEY (value)
However, there was no noticable improvement
in performance.
Even though loading the file into a table sans
primary key was very much faster, but adding
back the primary key negated any performance
improvement than if just loading the file into a
table with a primary key.
Jeff Tanner
Viathan
Seattle, WA
-----Original Message-----
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:33 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: LOAD DATA INFILE performance testing
Jeff Tanner writes:
>
> I running a test on mysql to test its performance of doing a bulk insert
> into a table using LOAD DATA INFILE.
>
> The table is simple:
>
> CREAT TABLE test (
> value CHAR(32) NOT NULL PRIMARY KEY
> )
>
> The test is simple:
> a) clear table
> b) time performance of inserting X unique values into table from a
> single file (each value on a new line)
>
> # of unique values time in seconds
> 10 0.05
> 100 0.05
> 1K 0.10
> 10K 0.75
> 100K 10
> 500K 125
> 1M 500
> 5M 55000
>
> My concern is the last entry of 5 million entries. Is there a mysql system
> variable I should reset to improve performance?
>
> Thanks
>
> Jeff Tanner
> Viathan
> Seattle, WA
No, but you could crate a table without index and add primary key
after loading of data.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
