RE: Load Data Infile quirk

2009-10-19 Thread mos
fied MySQL 5 Developer (CMDEV) IBM Cognos BI Developer Telephone +44 (0)7812 451238 Email j...@butterflysystems.co.uk -Original Message- From: mos [mailto:mo...@fastmail.fm] Sent: 17 October 2009 22:49 To: mysql@lists.mysql.com Subject: Load Data Infile quirk I'm trying to s

RE: Load Data Infile quirk

2009-10-18 Thread John
m] Sent: 17 October 2009 22:49 To: mysql@lists.mysql.com Subject: Load Data Infile quirk I'm trying to speed up Load Data Infile and after some experimenting have noticed this "qwirk". BTW, all of the tables used below are empty and have identical table structures. The value

Load Data Infile quirk

2009-10-17 Thread mos
I'm trying to speed up Load Data Infile and after some experimenting have noticed this "qwirk". BTW, all of the tables used below are empty and have identical table structures. The value being loaded into the primary key column is 'NULL'. Test1: 246 seconds to run Load Data Infile into a tabl