The best way to implement this is to use big objects. Big objects are custom objects that can store and manage massive amounts of data on the Salesforce platform. Big objects can handle hundreds of millions of records and support asynchronous SOQL queries. Big objects are also optimized for performance and scalability, and can be integrated with other Salesforce features such as reports, dashboards, and triggers. Setup audit trail, field audit trail, and field history tracking are not suitable for this scenario, as they have limitations on the number of fields, records, or retention periods that they can track. Reference: [Big Objects], [Trailhead: Big Objects Basics]