I have a web-app created for reporting purpose with over 150,000 rows
in the DB that has anywhere between 3-8 clauses being run on it
everytime someone creats a report.
Reports return back anywere from a couple hundred rows to over 100,000
if I am exporting it to excel.
Their is between 200-500 reports being created a day.
I was wondering how much ram and what hardware requirements do you
think such a system would require? Correct me if I am wrong but the
slowless I think is due to the amount of ram allocated to mySQL.
Apache needs to be restarted every couple of days.
Thanks for your input.