Hello, In our site, we have a doc type of 'Article', which has a property (contentPicker2) for selecting from another doc type, 'Bios' -- this associates an author to an article. Pulling the author name into the articles is pretty straightforward; we get the ID of the node and pull the properties from there, displaying the author's name from the Bio pages on the Article pages:

@{
IPublishedContent typedContentPicker = Model.Content.GetPropertyValue<IPublishedContent>("author");

if (typedContentPicker != null) {
var authorID = Model.Content.GetPropertyValue<string>("author");
<li><a href="@Umbraco.Content(authorID).Url"> @Umbraco.Content(authorID).Name</a></li>
}

}

Now I'm trying to do the opposite -- display articles that have been tagged with the author on their Bio page. I just need to pull from the Article content, and filter on articles that have been tagged with the current page's ID (the author selected in the content picker on the Article page). What I have now works:

@{var authorId = @Model.Content.Id;}

@{
    var recentArticles = Umbraco.TypedContent(1276).Children().Where(x => x.GetPropertyValue<int>("author") == @authorId).OrderByDescending(x => x.HasValue("publicationDate") ? x.GetPropertyValue<DateTime>("publicationDate") : x.CreateDate).Where(x => x.IsVisible()).Take(10);

    foreach(var item in recentArticles.){...}

}

-- but it is crazy slow to load. There are around 10k articles, so I can see why this might be the case. My question to the Umbraco gurus out there -- is there anything obvious that I am doing wrong here to cause the slow load time, or is it just the size of the query? If it is the size of the query, I'm assuming the solution might be to pull the results from an Examine index.

Any tips would be appreciated, thanks