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
---------------------------------------------------------------------
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
