WebDesigner IT Shop: performance issue (slow Product loading) (4382348)

In the WebDesigner IT Shop, when a user makes a new request and selects a category, loading the products and displaying them takes a considerable amount of time, even for categories with very few products.

Seems like a query runs after the user selects a category that checks all products of the category that must be displayed per page. If for example a category contains 30 products and 15 products are displayed per page, the query runs 15 times for each page and each query takes on average 2-3 seconds.

Configuration issue

To correct the issue, create a new index on BaseTreeHasObject and include the columns UID_Org, InheritInfo and ObjectKey.

CREATE NONCLUSTERED INDEX [IX_BHO_UIDOrg_InheritInfo_ObjectKey] ON [dbo].[BaseTreeHasObject]
(
[UID_Org] ASC,
[InheritInfo] ASC,
[ObjectKey] ASC
)

The IT Shop loads all the products instantly