Best database for Power App wrapped in Android app with large datasets and real-time updates?

Hello Power Platform community,

I have a Power App that is wrapped into an Android app and is running on around 30 devices. The app is currently using a SharePoint List as the backend, but we are facing challenges with:

Large Datasets: The data size is growing, and the current setup seems to struggle with the amount of data.
Real-time Data: The app requires real-time updates, and I’ve noticed some delays when updating and retrieving data.
Multiple Users: Multiple users are submitting and updating data simultaneously, so I need a database that can handle concurrent transactions without performance degradation.
Mobile Usability: Since the app is wrapped for Android, the solution should work smoothly in a mobile environment and integrate seamlessly with the Power Platform.

I am considering alternatives like Dataverse, Azure SQL, or Cosmos DB. Could anyone share their experiences or suggestions on the best database solution for this scenario? Specifically, one that scales well, supports real-time operations, and works well in a mobile setting.

Thanks for your input!

Categories:

General Questions

Mobile App