We are trying to retrieve the Meta data for Category Nodes that are a few levels down from the top. We are using the FindNodesDto to retrieve the nodes but we need the additional meta data fields. Currently after getting the category nodes from FindNodesDto we are loading the meta data using ContentLoader. The issue is this is really slow. We were wondering if there was a way to load the meta data with the FindNodesDto or another way to with better performance.

Our Catalog structure is:

• Level 1 (Manufacturer)
  • Level 2 (Series)
    • Level 3 (Machine)
      • Level 4 (Product Type) [This is the level we are retrieving]
        • Commerce Product Data

Here is the sql where clause for our FindNodesDto method call:

CatalogSearchParameters par = new CatalogSearchParameters();
par.SqlWhereClause = String.Format("CatalogNode.ParentNodeId IN " +
                    "(SELECT CatalogNodeId FROM CatalogNode WHERE ParentNodeId IN " +
                    "(SELECT CatalogNodeId FROM CatalogNode WHERE ParentNodeId IN " +
                    "(SELECT CatalogNodeId FROM CatalogNode WHERE Name = '{0}')))", cat.Name);

cat.Name is the Manufacturer name.