We are working on an early stage CRM Platform and we are currently suffering from slow request and database overload on bussiness inteligence and reporting pages,
I don't think we can continue working doing live request on database on potentially over 200K Leads and show results on real time.
What are the best practices for scaling? do we absolutly need to precalculate nightly all the reports?
Any help will be apreciated,
Thank you
