AFAIK, not many people use it. Of those who do, most use it for restoring
"backups" made with SELECT INTO OUTFILE, some use it for ETL with data
warehousing.
SELECT INTO OUTFILE is pretty useful to export data into a textual format
that other programs can read. I have no idea if the CSV engine negates that
need. But LOAD DATA INFILE is a logical complement to SELECT INTO OUTFILE.
It's not really that hard to convert a delimited file into a file that can
be used with the import function ("source" in a mysql client or mysql <
foo.sql). This is what I usually do if I have a partial load of data, ie
changing
foo,bar,baz
to
INSERT INTO tbl (fld1, fld2, fld3) VALUES ('foo','bar','baz');
The purpose of Drizzle is "a Microkernel DBMS for High Performance Scale-Out
Applications". How often do "high performance, scale-out applications"
bulk-load data?
I would say that bulk-loading data is not essential to a high performance,
scale-out application....then again, the point of LOAD DATA INFILE is that
it does it faster than INSERT statements.
For full table imports, the CSV storage engine could be used (tweaked
perhaps, instead of just using commas as the delimiter, be able to specify
the "FIELDS DELIMITED BY", "FIELDS [OPTIONALLY] ENCLOSED BY" and "FIELDS
TERMINATED BY" characters?). Or not, as a developer can make a conversion
script to convert a non-CSV text file to one that is comma-separated (adding
quotes, escaping commas and quotes, etc).
In short -- it's rarely used, though those that use it are adamant about
it. Still, Drizzle isn't everything to everyone....
-Sheeri
On 11/28/08, Brian Aker <[EMAIL PROTECTED]> wrote:
>
> Hi!
>
> What is the current thinking for LOAD DATA LOCAL INFILE?
>
> I have heard plenty of complaints about the "LOCAL" version, but I can not
> say I have ever understood why they exist.
>
> Cheers,
> -Brian
>
> --
> _______________________________________________________
> Brian "Krow" Aker, brian at tangent.org
> Seattle, Washington
> http://krow.net/ <-- Me
> http://tangent.org/ <-- Software
> _______________________________________________________
> You can't grep a dead tree.
>
>
>
>
> _______________________________________________
> Mailing list:
> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss>
> Post to : [email protected]
> Unsubscribe :
> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss>
> More help : https://help.launchpad.net/ListHelp
>
--
- Sheeri K. Cabral
Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a
remote DBA firm, and consulting would constitute a conflict of
interest. However, I do recommend our work, and if you're looking for DBA
work (I do MySQL work, but they have great Oracle and SQL Server DBAs too)
right now, whether you need a few hours a week, or someone fulltime while
you continue a job search.
I have a webpage with tips on how to find a DBA:
http://sheeri.net/how-to-find-a-dba/
I can recommend http://www.toomanyconnections.com as a good site to find
MySQL (and Oracle) DBAs.
If you're looking for web design, I recommend the small business my husband
works for, http://www.digital-loom.com
I regret that I have no other information for any other type of position,
including developer, programmer and systems administrator.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
