Showing results for 
Search instead for 
Did you mean: 
Level 8

Local Collection vs. Azure SQL Table performance

This may sound like a silly obvious question but I just had a bulb go off over my head. There is likely a huge perfromance difference between manipulating a local collection vs. patching / refreshing from an Azure SQL database right? Even if I essentially cache locally then write patches to SQL I am assuming it would be faster right? I don't know why I hadn't thought of this sooner, I have been almost always pulling a full table (or filtered one) from SQL rather than just write patch / remove from collection to maintain local copy.


The only issue with this is if you have more than one user acting upon a list at any given time, then you must always refresh from SQL to make sure data is up to date right?

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 89 members 5,054 guests
Please welcome our newest community members: