I'm attempting to import 36 files of varying size from about 500kb to 80mb. I've found that using the "local infile import" query on files that are several mb in size takes up to a min per mb and much longer if it get's over 100mb. The system we're using has 500mb RAM and a 1600mHz processor. Is there a faster way to do these bulk imports? This is supposed to be faster than the insert function especially on large numbers of imports. Can anyone tell me anything about this to speed this up perhaps?
Thank you, Sarah --------------------------------------------------------------------- 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