I have a web portal which majorly does 3 tasks:
1. Bulk Import by Uploading Excel (around 12000 rows with 40-45 columns in each row)
2. Bulk Export to Excel
3. Multipage PDF creation with mpdf
The things are working but the excel upload work is toooo slow. The speed I am getting is roughly 75-100 records per minute. This mean it will take 2+ hours to upload complete excel but on reaching around 4k records, things get stopped may be because of firewall/antivirus/wamp settings. We have worked intensly on configurations, but no wonders till now.
You are required to optimize the settings of wamp to increase the performance by increasing the speed and throughput.
Development Machine: Wamp 64 bit, Windows 10 64 bit, 8 GB RAM, Intel i7
Client Machine: Wamp 64 bit, Windows 7 64 bit, 4GB RAM, Pentium Dual Core
Note: You will be paid for 1 hour only.
I am submitting this proposal as a FREELANCER. Though I am new to this platform but having very deep understanding of web application development and relevant technologies. Instead of describing various technical capabilities, I love to face interview to prove my capabilities before you.
I have good experience of code refactoring and application optimization.
I urge you to give me a chance and invite me for an interview, I assure you that you won't be disappoint.