Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Database input speed question

by JSchmitz (Canon)
on Jul 31, 2003 at 19:47 UTC ( #279751=note: print w/replies, xml ) Need Help??


in reply to Database input speed question

I would not use LOAD DATA INFILE it is kinda of a drag compared to the much slicker mysqlimport which should be located in /usr/local/mysql/bin. Check that out you won't be dissappointed.

cheers
Jeffery

Replies are listed 'Best First'.
Re: Re: Database input speed question
by jest (Pilgrim) on Aug 01, 2003 at 08:14 UTC

    It's not "much slicker", it's just a command-line version of the same thing! The LOAD DATA INFILE is an SQL command; the mysqlimport is a command-line interface to that SQL command. They're used in different situations. See the docs.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://279751]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (5)
As of 2018-08-20 06:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Asked to put a square peg in a round hole, I would:









    Results (190 votes). Check out past polls.

    Notices?