I'm storing some data in the RootFolder.Properties for a bunch of subsites, sub-subsites and sub-sub-subsites. On the parent site(s), I want to roll up that data, security trimmed for the user. (All are in the same site collection)
Obviously, looping over all SPWebs would be terribly expensive. There is the Content Query WebPart, which I assume does something a lot more effective. Does anyone know what it actually does under the hood, and if I can leverage that to roll up known SPWeb.RootFolder.Properties?