Return to Question

[![Fast Insert][1]][1]

[![Slow Insert][2]][2]

[![Fast Delete][3]][3]

[![Slow Delete][4]][4]

Why is that? [1]: https://i.sstatic.net/Lyqcw.png [2]: https://i.sstatic.net/goz7N.png [3]: https://i.sstatic.net/IJyqv.png [4]: https://i.sstatic.net/FDdJT.png

Why is that?

EDIT 1: Thanks for your comments, now I realize that delay also happen on the delete! here are some stats using the suggested Paul Randal script, taking 3 minutes on each test

Fast Insert:

[![Fast Insert][1]][1]

Slow Insert:

[![Slow Insert][2]][2]

Fast Delete:

[![Fast Delete][3]][3]

Slow Delete:

[![Slow Delete][4]][4]

So, on slow operations there are more number of reads/writes, but a small number of bytes. Right?

Also the delete is on the primary key, why take more time for the same amount of subscribers?

Why is that? [1]: https://i.sstatic.net/Lyqcw.png [2]: https://i.sstatic.net/goz7N.png [3]: https://i.sstatic.net/IJyqv.png [4]: https://i.sstatic.net/FDdJT.png