Note: This is very urgent requirement. I am in US Eastren time zone available from 10am - 12:00 midnight
You must communicate in SKYPE or GTALK.
You need to finish this work in 1 Day if not in 2 days. Do not bid if you do not have time
Here is the work:
Task # 1
currently i am using perl scripts to load product data into mysql tables and it is taking very long time to run.
it takes data from excel spread sheet and use template and load it to mysql database and after finishing it will
download as .sql file This whole process is taking long time because we have large data
We can avoid loading to mysql and create a similar format file as csv file and execute multiple threads so it will
run and finish faster.
once above task # 1 is finished we are running another task wcich executes another perl script to do replacements
of variiable values again it uses mysql database to load data and perform replacemnts. if you expert in perl
you can do this on unix machine i have server and complete the task much faster.
Just to give example - currently for task # 1 to process 20mb file which will create 1.5gb .sql file it takes about 3 to 3.5 hours, like this i can only process 7 to 8 files per day.
This is for task 1 and for task 2 it takes equal amount of time.
I need your dedicated support to finish this project.
Note; these are existing perl scripts. you need to provide a work around or redo to finish each task in 5 to 10 minutes
Majority of time is consuming to create intermediate csv files, parsing, loading to mysql.
My estimate for this work is $40.00. But i can pay 50% more if you are skilful and finish the task on time.