On Fri, Jan 17, 2003 at 06:46:09PM +0530, Shripal Shah wrote: > Dear Sir/Madam > > I want to know that which is more faster in terms of loading data into table > from file > > 1> MYSQL --quick -f -s -u root DBNAME < FILE.TXT > > 2> LOAD DATA INFILE.....
Try both and you'll know. :-) Seriously, there's no absolute answer. It depends on many factors. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 33 days, processed 1,093,732,361 queries (373/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
