Answered

Dataverse speed compared to Lists

(1) Share

Report

Posted on by Roric

Built my first productive Power App last year. Works almost flawlessly. Unfortunately its painstakingly slow. I calculated, that the collection of an additional record for the list I use adds 0.4 seconds to the loading and reloading times. So when we will be up to 200 record soon, you can get a coffee while loading.

The records have many columns and these are all needed, since there are so many functionalities. Can't reduce on the column side
Does it make sense to switch to a App driven by dataverse rather then the list in a sharepoint site?

What will be the time benefit in using dataverse?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!
I find that SharePoint Lists are good if you data has small set of records (e.g. in the 100s) and one list. Dataverse is better for data growth.

Some of the benefits of Dataverse over lists are:
Security and Permissions can be managed better for the data. For example:
SharePoint manages its security based on the site/library where as the DV Tables can have their own permissions.
DV has column level permission.
If your app grows you may need to create relationships between data entities. e.g. having table relationships.
You can potentially speed up data loading in Dataverse depending on what and how you are doing it.

--------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
Roric 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer.
I read out of your answer, that the speed is not so much the advantage of Dataverse. So, in your experience a acceleration of multiple times is not real with DV?
That would imply I rather have to rethink the architecture of my data. For instance I already use multiple tables, but these could to some extent be even fragmented to more tables and implementing appropriate relationships. These relationships could be implemented in the lists.
In the end the loading has to be accelerated multiple times, so the users accept my App. Not just a percentage. What is the key to that?

Was this reply helpful? Yes No
Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Roric,

Performance is going to based on a number of factors, it's not simply based on SharePoint vs Dataverse. When working with a Canvas app, you have full control over the user interface and the behavior, which means there are many opportunities for performance to be impacted by something as simple as an unoptimized formula, loading too much data, too many controls on the screen, etc. It's unlikely that its an issue with the data sources in itself, but rather with how things were configured and the Canvas app was designed.

I suggest reviewing these guides on how to troubleshoot and and optimize performance in Canvas apps.

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/common-performance-issue-resolutions

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/performance-tips

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Roric 10 on at

Like (0)

Report
Copy link

Link copied!

Still, do you have any rules of thumb how much the difference of DV to Lists is (of course only for a model dataset specified for the comparison)?

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Roric

Is this a Model-driven or Canvas app?

Loading 200 records to a canvas app from a SP List should be lightning quick! For example, I has a Canvas app loading data from 2 SP Lists

- List 1, loads in ~7,500 records in 10sec

- List 2, loads almost 24,000 records in 30sec

So, around 40s to load over 30,000 records and loading all columns.

This could be greatly sped up even more by using the Concurrent() function but I use a dynamic formula to load my data instead of a static one that Concurrent() would need.

Was this reply helpful? Yes No
Roric 10 on at

Like (0)

Report
Copy link

Link copied!

Hi EddieE
thanks for this valuable information.
My app is a canvas app. The relevant list has 16 Columns i use. Yes, I will try to use concurrent to speed up with the other smaller Lists to load...

Was this reply helpful? Yes No