I have a rather complex spreadsheet formula. Right now I am using PHPExcel to load the spreadsheet into memory, and I set the cell values of the formula input to the values from a front-end form (using ajax), get the calculated result and send it back to the client.
Is this the best way to this? Or should the formulas be converted to pure php?
If this is an okay method, I have concerns regarding concurrency and memory usage.
The spreadsheet isn't that large, less than 1000 cells. How can I calculate the threshold for concurrency (people clicking calculate on the front end) and memory usage on the server?
What steps can I take to optimise this algorithm (caching for example) whilst balancing performance?