Displaying 1 result from an estimated 1 matches for "import_data_file".
2006 Dec 18
3
Creating another database connection for large mysql import?
I''m using backgroundrb to periodically download a large file via ftp from a
remote location and then import it into the database. To perform the
import, I was using the following:
ActiveRecord::Base.connection.execute(%{load data infile ...;})
although on a file with 2.5 million records, this can take 5 minutes, which
seems to tie up my rails application while this executes (even