We are looking to expand our current outsourcing partners (PHP-MySQL) for long term relationship. We need skills and professionalism. Here is the assignment:
This job is for uploading and inserting some data from a text file into MySQL database. The file may contain more then 100,000 mysql records, each field separated by comma, and each row separated by line break (n).
The file is a text file (.txt) and it will be zipped and password protected using winzip or some other file compression program.
The server is a linux server, and the password protected zip file need to upload on server where it will be automatically extracted and send to MySQL, just assume that we have same number of field on the text data file such as MySQL table so no need validation for now. But immediately after extraction the whole data need to insert into MySQL, as because the amount of data is huge so this program to insert data into MySQL need to develop in such a way so it will utilize minimum amount of server resources.
Indicate the time to execute. Thanks.