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.