Question: what's the most efficient way to retrieve unpublished data?
Initially I used Document.GetDocumentsOfDocumentType(id) to get the documents and AutoMapper to translate them onto my model objects.
But I've discovered the performance is very poor as it runs a db query to retrieve each custom property's data. I had about about 500 documents of a particular type, with 5 custom properties, and it was taking 20 seconds to do a translation to my model.
Hi Harv, unfortunately the NodeFactory won't help as this works with the published XML - I wonder if you could use Examine to index unpublished nodes and use this as your data source ?
Question: what's the most efficient way to retrieve unpublished data?
Initially I used Document.GetDocumentsOfDocumentType(id) to get the documents and AutoMapper to translate them onto my model objects.
But I've discovered the performance is very poor as it runs a db query to retrieve each custom property's data. I had about about 500 documents of a particular type, with 5 custom properties, and it was taking 20 seconds to do a translation to my model.
Would using NodeFactory have better performance?
Hi Harv, unfortunately the NodeFactory won't help as this works with the published XML - I wonder if you could use Examine to index unpublished nodes and use this as your data source ?
I see, so the NodeFactory is just like LinqToUmbraco in that they both only use published data.
I'm not sure what you mean by Examine? What is it?
is working on a reply...