This is with version **8.1.1.0**

45,000 Rows **without** memory preference set.

Iteration for cell took: 71.00

Iteration for cell took: 4,797.00

Iteration for cell took: 4,805.00

Iteration for cell took: 5,898.00

Iteration for cell took: 5,210.00

Iteration for cell took: 5,325.00

Iteration for cell took: 5,018.00

Iteration for cell took: 5,373.00

Iteration for cell took: 5,157.00

Iteration for cell took: 4,828.00

and stays between 4,500 and 6,000

45,000 rows **with** memory preference set.

Iteration for cell took: 75.00

Iteration for cell took: 166.00

Iteration for cell took: 211.00

Iteration for cell took: 256.00

Iteration for cell took: 337.00

Iteration for cell took: 431.00

Iteration for cell took: 495.00

Iteration for cell took: 564.00

Iteration for cell took: 566.00

Iteration for cell took: 637.00

Iteration for cell took: 716.00

Iteration for cell took: 778.00

Iteration for cell took: 896.00

Iteration for cell took: 935.00

Iteration for cell took: 995.00

Iteration for cell took: 1,082.00

Iteration for cell took: 1,186.00

Iteration for cell took: 1,251.00

Iteration for cell took: 1,296.00

Iteration for cell took: 1,462.00

Iteration for cell took: 1,470.00

Iteration for cell took: 1,444.00

Iteration for cell took: 1,546.00

Iteration for cell took: 1,741.00

Iteration for cell took: 1,791.00

Iteration for cell took: 1,661.00

Iteration for cell took: 1,710.00

Iteration for cell took: 1,804.00Iteration for cell took: 75.00

Iteration for cell took: 166.00

Iteration for cell took: 211.00

Iteration for cell took: 256.00

Iteration for cell took: 337.00

Iteration for cell took: 431.00

Iteration for cell took: 495.00

Iteration for cell took: 564.00

Iteration for cell took: 566.00

Iteration for cell took: 637.00

Iteration for cell took: 716.00

Iteration for cell took: 778.00

Iteration for cell took: 896.00

Iteration for cell took: 935.00

Iteration for cell took: 995.00

Iteration for cell took: 1,082.00

Iteration for cell took: 1,186.00

Iteration for cell took: 1,251.00

Iteration for cell took: 1,296.00

Iteration for cell took: 1,462.00

Iteration for cell took: 1,470.00

Iteration for cell took: 1,444.00

Iteration for cell took: 1,546.00

Iteration for cell took: 1,741.00

Iteration for cell took: 1,791.00

Iteration for cell took: 1,661.00

Iteration for cell took: 1,710.00

Iteration for cell took: 1,804.00

I also noticed that the DeleteRange calls were taking a very long time, so during my application run, I need to keep toggling the memory mode: Preference during Inserts and Normal during Deletes.

I pulled down 8.1.2 and with the toggling the numbers have improved even more. (With the toggle)

Iteration for cell took: 69.00

Iteration for cell took: 89.00

Iteration for cell took: 85.00

Iteration for cell took: 95.00

Iteration for cell took: 99.00

Iteration for cell took: 106.00

Iteration for cell took: 112.00

Iteration for cell took: 127.00

Iteration for cell took: 128.00

Iteration for cell took: 139.00

Iteration for cell took: 141.00

Iteration for cell took: 158.00

Iteration for cell took: 160.00

Iteration for cell took: 172.00

Iteration for cell took: 218.00

Iteration for cell took: 189.00

Iteration for cell took: 229.00

Iteration for cell took: 212.00

Iteration for cell took: 215.00

Iteration for cell took: 218.00

Iteration for cell took: 220.00

Iteration for cell took: 229.00

Iteration for cell took: 243.00

Iteration for cell took: 246.00

Iteration for cell took: 259.00

Iteration for cell took: 341.00Iteration for cell took: 69.00

Iteration for cell took: 89.00

Iteration for cell took: 85.00

Iteration for cell took: 95.00

Iteration for cell took: 99.00

Iteration for cell took: 106.00

Iteration for cell took: 112.00

Iteration for cell took: 127.00

Iteration for cell took: 128.00

Iteration for cell took: 139.00

Iteration for cell took: 141.00

Iteration for cell took: 158.00

Iteration for cell took: 160.00

Iteration for cell took: 172.00

Iteration for cell took: 218.00

Iteration for cell took: 189.00

Iteration for cell took: 229.00

Iteration for cell took: 212.00

Iteration for cell took: 215.00

Iteration for cell took: 218.00

Iteration for cell took: 220.00

Iteration for cell took: 229.00

Iteration for cell took: 243.00

Iteration for cell took: 246.00

Iteration for cell took: 259.00

Iteration for cell took: 341.00

Also with the new 8.1.2 version, the toggling actual ran slower. I'm running entirely in Preference mode and the performance has improved by 90%.

Thanks for you and your teams efforts.