Hi friends,
Was hoping to get some advice on what is the best datasource to use for an app that has a large amount of data.
The app is currently in use and all data is being stored on SharePoint.
- The app allows users to capture orders which are then allocated to someone to complete (ListName: Orders)
- There are currently 1000-3000 orders captured per day
- In order to keep the system quick, there is a flow that runs a few times a day that archives orders in another list (ListName: OrdersArchive)
- The OrdersArchive currently holds about 800 000+ captured over the 1.5 years
- There are other lists now in use and these are also growing
Although SharePoint can handle the storage of this, the issue now is that querying, analysing, exporting etc of the data has become rather difficult.
There also a few flows that run to send summary reports and the eventuality is that amount of data will become a blocker.
The idea is to move it to Dataverse or SQL, though it seems Dataverse is the winning option for now taking into account the barriers to enter with Azure SQL and how enterprise IT manages their process as well as the options you have with analyzing data.
Any advice on this? Should we stick it out in SPO? How many rows can Dataverse actually handle?
Appreciate the support!
