Is there some way to measure number of items read per item in the Content Editor

Question

I'm wondering if there is any diagnostic tool, or technique which can be used to work out how many items are read from the DB for each item loaded in the content editor. I'm thinking of a Content Editor equivalent of the rendering statistics admin page. I know I could look at all inherited templates and look at any fields which are link fields or TreeList fields (or similar) and perhaps figure out how many queries/requests there are, but it would be pretty tedious.

My end goal is to quantitatively measure the benefit of changing certain field types from e.g. TreeList to TreeListEx to see how this will affect Content Editor performance.

Answer 1

I haven't tried that but maybe adding your own processors at the beginning and at the end of <getContentEditorFields> pipeline would do the trick?

And then using

Sitecore.Diagnostics.PerformanceCounters.DataCount.DataItemsAccessed.Value

to get the number of items read - you can store the initial value in Sitecore.Context.Items cache as it is a per-request cache, and then compare it with the value at the end of pipeline.