I have product feeds in plain text file from various vendors but all of them are in the same format. The feed delivered to my server via FTP everyday. So, the script will work all the time.
I need someone to write me a script that imports 16 GB data in less than one hour. The script should not kill my server or mysql.
I already tried LOAD DATA INFILE but it imports only one row. I am ready to pay even if you tell me why it is not importing all the rows.
Only experienced coders please.