Power Apps – comparing the speed of writing to Excel, Sharepoint and Dataverse
Author: Martin Bradáč
Most of Power Apps is connected to database. But which kind of database to use?
There are big differences in performance, which is manifested mainly in writing a large amount of data.
This test compares Excel, Dataverse, SharePoint, SQL in Azure and On Premise SQL.
All data sources have a table with two columns. We write the contents of the collection with 1000 rows into it. For writing, the standard ForAll – Patch construction is used.
Results are calculated as an average of multiple runnings.
The winner and loser is no surprise.
Dataverse was able to perform 1 000 writings in 139 seconds. Excel finished in 1 294 seconds and, by the way, it ended with an error on the number of API calls.