Measuring query time for the masterclass shop category product listing without price calculations

gistfile1.txt

// Find category by slug

Running ToList() query on index at file:///c:/inetpub/masterclass/Website/App_Data/Ucommerce/Indexes/Category-95984832/en-US:
- Where clauses: cat => (cat.Slug == value(MyUCommerceApp.Website.Controllers.MasterClassCategoryController+<>c__DisplayClass4_0).slug)
- Native query: +Slug:sausages @0
- Native query with facets: +Slug:sausages @0
- Done searching @6
= Hits: 1 of 9 total.
= Spent 3 msecs retrieving docs
= Spent 2 msecs unwrapping docs
= Query time: 12 msec


// Get 100 products

Running ToList() query on index at file:///c:/inetpub/masterclass/Website/App_Data/Ucommerce/Indexes/Product-e95f4fb2/en-US:
- Where clauses: p => p.Categories.Contains(value(Ucommerce.Api.CatalogLibrary+<>c__DisplayClass28_0).categoryId.Value)
- Native query: +Categories:a8eab330-cfb6-21bc-708f-ba5e87fd430f @0
- Native query with facets: +Categories:a8eab330-cfb6-21bc-708f-ba5e87fd430f @0
- Done searching @44
= Hits: 100 of 2279 total.
= Spent 19 msecs retrieving docs
= Spent 7 msecs unwrapping docs
= Query time: 73 msec


// GetRootCategories

Running ToList() query on index at file:///c:/inetpub/masterclass/Website/App_Data/Ucommerce/Indexes/Category-95984832/en-US:
- Where clauses: cat => ((Convert(cat.ProductCatalog) == value(Ucommerce.Api.CatalogLibrary+<>c__DisplayClass25_0).catalogId) AndAlso (cat.ParentCategory == null))
- Native query: +(+ProductCatalog:8c9037cc-f1f2-f477-7f15-999d1d55e29d +(+*:* -ParentCategory:*)) @0
- Native query with facets: +(+ProductCatalog:8c9037cc-f1f2-f477-7f15-999d1d55e29d +(+*:* -ParentCategory:*)) @0
- Done searching @5
= Hits: 11 of 11 total.
= Spent 35 msecs retrieving docs
= Spent 20 msecs unwrapping docs
= Query time: 62 msec


// Get selected category's sub categories

Running ToList() query on index at file:///c:/inetpub/masterclass/Website/App_Data/Ucommerce/Indexes/Category-95984832/en-US:
- Where clauses: p => value(Ucommerce.Api.CatalogLibrary+<>c__DisplayClass27_0).categoryIds.Contains(p.Guid)
- Native query: +(Guid:2a52f169-42c4-939d-b246-288cdb4b5d41 Guid:85793c6d-0a30-3e93-382a-0896c061e210 Guid:53c77676-c4e2-039e-1945-cc53f6fbbbed) @0
- Native query with facets: +(Guid:2a52f169-42c4-939d-b246-288cdb4b5d41 Guid:85793c6d-0a30-3e93-382a-0896c061e210 Guid:53c77676-c4e2-039e-1945-cc53f6fbbbed) @0
- Done searching @7
= Hits: 3 of 3 total.
= Spent 11 msecs retrieving docs
= Spent 6 msecs unwrapping docs
= Query time: 26 msec