Unanswered

Sharepoint vs Azure SQL performance in Apps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All

I have developed several apps where I am connecting to SharePoint and pulling a record or a handful of multiple records via a text lookup key. The SharePoint lists vary in size, anywhere between 1k and 20k rows.

The performance of these apps seems quite unstable in terms of data loading times; using Lookup or Collect on a SharePoint list sometimes takes 1 second and sometimes takes 30 seconds. Using this forum I've tried multiple strategies to improve this, but users continue to complain about slow and inconsistent loading times.

We are considering moving to Azure SQL mainly to improve in-app performance (among other benefits). I am looking for some validation here -- has anyone switched from SharePoint to Azure SQL and seen improved performance in apps?

I have seen a few comments saying this should help but yet to find a case where someone has actually switched and seen the performance improve. Considering Azure SQL is a premium connector I need to make sure I will see "premium" improvements 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

For best performance in Powerapps with regards to Datasource, consider either Azure SQL or CDS. These are ahead of SharePoint in several ways.

Read On Datasource comparison:
https://baizini-it.com/blog/index.php/2017/08/29/powerapps-101-data-storage/

I personally use Azure SQL
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
mogulman 764 on at

Like (1)

Report
Copy link

Link copied!

What I did was develop the app using on-premise SQL Server and SQL Server Express. The reason I did was to be able to use SQL Profiler. It really helped optimize performance. Once I had it working properly I migrated to Azure SQL DB. It was simple to do. I found the use of views and collections good techniques to improve performance.

Was this reply helpful? Yes No