- When browsing to a particular page on website, DB usage starts to go up to 100% within a minute.
- SDL Web 8.5 is installed, and DD4T 2.2 used for website.
- Same code was used on a Tridion 2013 SP1 website, and did not exhibit the offending issue.
- Queries which are most frequently called and are longest are category/keyword related queries.... components on the page in question use keywords.
- Both object cache and application cache (on presentation layer) are enabled.
- Other pages besides the offending page will also take excessively long to load, perhaps 30 seconds max.
- Below code takes six seconds to execute
var filter = new CompositeFilter();
filter.DepthFiltering(DepthFilter.UnlimitedDepth, DepthFilter.FilterDown);
taxonomyFactory.GetTaxonomyKeywords(tcm:20-76-512, filter, new TaxonomyListFormatter()).KeywordChildren.Cast<Keyword>().ToList();
- Below code takes 90 seconds maximum to execute.
query.ExecuteQuery();
query.Criteria
{Tridion.ContentDelivery.DynamicContent.Query.AndCriteria}
IsOperator: true
query.SetResultFilter(new LimitFilter(6));
query.AddSorting(sortParam);
criteriaList is made up of the following
{Criteria: PublicationCriteria, operator: =, publicationId: 20}
{Criteria: ItemSchemaCriteria, operator: =, schemaId: 27918}
{Criteria: TaxonomyKeywordCriteria, publicationId: 20, taxonomyId: 77, taxonomyKeywordId: 15414, includeKeywordBranches: False}
{Criteria: CustomMetaValueCriteria, operator: =, metaDataType: FLOAT, metadataField: brandAssociationCount, keyValue: 1}
Criteria clientNameCriteria = new TaxonomyKeywordKeyCriteria(tcm:20-76-512, "KEYWORD_NAME", false);
query.Criteria = new AndCriteria(criteriaList.ToArray());
query.Criteria.AddCriteria(clientNameCriteria);
- Webpages are slow to load when taxonomy hierarchy is hit at the lowest level. Going up the hierarchy tree, page loads are much faster.