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.