Working on a site with content areas with many content area items, I was profiling the site and database to improve the first load performance of the site.

I attempted to batch load all items when rendering each content area (in a CustomContentAreaRenderer, using IContentLoader.GetItems). But before even reaching my batch loading code, it turns out Episerver had already loaded each block individually and sequentially. Actually, for most of of the blocks it even called two stored procedures per content area item: netFindContentCoreDataByContentGuid and netContentDataLoad.

It would be really nice if Episerver could batch load all the blocks, when enumerating ContentArea.Items, instead of loading individually?

Or Episerver could just batch preload ContentAreaItem (calling netFindContentCoreDataByContentGuid) when calling ContentArea.Items. Then the actual content could be batch loaded in a CustomContentAreaRenderer.