Showing results for 
Search instead for 
Did you mean: 
Community Champion
Community Champion

Very poor CDS performance in deleting records, any ideas?

It takes > 5 minutes to delete just 500 of the 5,000 records from a CDS entity by using the following code as suggested in the documentation for the Clear function

RemoveIf(CdsEntity, true)

This is very poor perfomance, and there is no way to delete all records at once.

Does anyone have a better idea of how to truncate a CDS entity?

Memorable Member
Memorable Member

If the issue just started it might be related to the overall CDS issue that others are reporting (including myself)


Check the forum post here, lots of other CDS related issues all of a sudden:


No word at all on a fix from MS (as per usual)

Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,338)