https://community.developer.cybersource.com/t5/Integration-and-Testing/DB-Structure-for-Large-Scale-SAAS-CRM/m-p/69768#M42729 <P class="_1qeIAgB0cPwnLhDF9XSiJM">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,</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I don't think we can continue working doing live request on database on potentially over 200K Leads and show results on real time.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">What are the best practices for scaling? do we absolutly need to precalculate nightly all the reports?</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Any help will be apreciated,</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Thank you</P> Thu, 21 Nov 2019 11:59:28 GMT JamesWilliams 2019-11-21T11:59:28Z https://community.developer.cybersource.com/t5/Integration-and-Testing/DB-Structure-for-Large-Scale-SAAS-CRM/m-p/69768#M42729 <P class="_1qeIAgB0cPwnLhDF9XSiJM">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,</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I don't think we can continue working doing live request on database on potentially over 200K Leads and show results on real time.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">What are the best practices for scaling? do we absolutly need to precalculate nightly all the reports?</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Any help will be apreciated,</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Thank you</P> Thu, 21 Nov 2019 11:59:28 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/DB-Structure-for-Large-Scale-SAAS-CRM/m-p/69768#M42729 JamesWilliams 2019-11-21T11:59:28Z