Hi,
Thank you for your query.
What is the purpose of this data? Do you need to do any transactions on this data or is this for reporting purposes? Also, do you need to create relationships with this table?
In my opinion, if this data is not being used in a Dataverse transaction, I will not store it in Datavsers for the following reasons:
- The cost of storage will increase, I would recommend doing math on how many GBs you would require. For your reference, one of my clients has around 15mil of records in the Activity table and the table size on disk is around 700GB (luckily it's on-prem).
- Datsaverse tables have other metadata fields (like Created On, Modified By), which will increase the size of this table (when records are 39 million it matters).
- If the table is created with user ownership, it will have relationships with User and Team entities, which might impact the performance.
- Dataverse create filtered views on top of tables, which are costly, especially when the number of records is 39m.
Depending on the need, I will either store this data in Azure Datawarehouse, Azure Blob storage, or a Datalake. Then I will build controls or reports to user/show this data on-demand in the dataverse.
