Power Platform Community Forum Thread Details

I have a Forall function patching records from a Collection to sql server.

Talking over 13 minutes to patch 1000 records.

Is there a way to increase the speed of this ?

ForAll(colFinal,
Patch(t_redbook_pricing_escalation_detail_pa,
Defaults(t_redbook_pricing_escalation_detail_pa),
{RBP_MASTER_ID: Value(Column1),
SKU: Column2,
PRODUCT_DESCRIPTION: Column3,
QTY: Value(Column4),
TARGET_PRICE: Value(Column5),
TARGET_GP: Value(Column6),
CURRENT_PRICE: Value(Column7),
CURRENT_GP: Value(Column8),
VENDOR_GUIDELINE_GP: Value(Column9),
QRP: Value(Column10),
APPROVED_PRICE:Value(Column11),
APPROVED_GP: Value(Column12),
RENEWAL_SKU: Column13
}
)
)