Power Platform Community Forum Thread Details

Hello

My RemoveIf function takes too long to execute. My tables are located on an on-premises SQL database. Can someone help me optimize my code?

Concurrent(
RemoveIf(
Profile,
USR_LogonName = ComboBox_USR_Logon.Selected.USR_LogonName
),
RemoveIf(
Groups,
USR_LogonName = ComboBox_USR_Logon.Selected.USR_LogonName
),
Clear(colCombination);

)

Categories:

Building Power Apps

Hi @SlyFox,

At a first glance, the code looks quite good to me - using concurrency. However, please keep the following aspects in mind:

Deleting records in bulk within Power Apps will take a bit of time, no matter how performant your code is written. You could alleviate this issue by trying to spread the processing throughout different screens/points in your app instead of all at once. UI/UX wise you could add a loading spinner or a loading bar.
Large bulk CRUD operations should be avoided in Power Apps and should preferably be done (if possible asynchronously) in the back-end (Some examples could be Power Automate / Azure Logic App with a concurrent Apply To Each & SQL delete action or, maybe even better in this case, Power Automate calling a SQL Stored Procedure)
The SQL connector has a throttling limit of 100 calls per 10 seconds (Power Apps monitor might provide you more insight on whether you hit this limit)