Reports and Analytic for big data

I’m looking for an advise on how to handle large number of records in reports.
In my use case I might have million of records a month which I’ll keep a 3 month history of.
These records are for user activity and should be available for reporting and analytic.
This activity records are associated with other records I manage like a Subscriber record…

Did anyone trey working with big data in SF?
What is the recommended approach?
Is it at all doable?

If not what is the suggested alternative? Database.com? Something else?

Answer

You can contact customer support to get the fields used for filters in your reports to be indexed (custom indexing), this could improve the reports performance.

However having said that i would recommend having an external system to store these hisotrical activities on periodic basis and run reports on it. Salesforce.com space can be extended but its not cheap moreover after some time maintaining the large data (archiving and deleting) in itself becomes a huge task and would incur additional IT overhead.

Attribution
Source : Link , Question Author : Dedo , Answer Author : Modem

Leave a Comment