On Nov 28, 2008, at 14:37, Brian Aker wrote:
What is the current thinking for LOAD DATA LOCAL INFILE?
As Jim said the non-local version is pretty useless.
The local version is great for bulk loading data though. It might
have changed, but at least in the past it was much faster to write a |
separated file and loading it with "LOAD DATA CONCURRENT LOCAL INFILE
'$filename' REPLACE INTO TABLE foobar" than it was to write replace
into statements and running those.
I just checked and one of my clients is still using it to load ~100m
records every Friday evening. On the old-ish hardware we're using
there I'm pretty sure using plain SQL would bring it from "takes a few
hours" to "not practical".
- ask
--
http://develooper.com/ - http://askask.com/
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
