I currently have a computer i use as a web server to process a lot of data.
It is running windows 7 using Apache, PHP, Mysql.
My system actually accepts no external traffic, it is really just a series of cron jobs and tasks managing my companies stock and customer record data.
On average there are around 40 million+ SQL queries daily, and I am currently developing a few new scripts that are gonna need twice the resources again.
Queries per second avg: 476.36
At most there could be 5-10 scripts running at once (all long scripts that can be heavy on resources)
I need a setup that could handle / run these queries and data faster, what sort of spec should i be looking at?