G'day CPT John W. Holmes and Rory
>> AFAIK, LOAD DATA INFILE will only work off a file. So you would have to
>> create a temp file. Another option is to create a multiple value insert
>> query e.g.
> Agree that LOAD DATA INFILE will probably still be faster overall, even with
> the file write. Try each and see, though.

I kinda figured this would be the case. As there could potentially be a huge
number of rows I was worried about doing an insert. I ended up writing a
temp file, loading it and then deleting it. It's quite fast and seems to
work just fine.

Cheers and thanks again for the suggestions


PS. Does everyone else sometimes get multiple copies of posts? I posted just
one message but I got it three times via the list.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to