Hi guys,
Sorry - I have another bug after upgrading to v2.2.2...
The list of product attribute combinations in the backend (e.g /Admin/Product/Edit/1234 --> "Attributes" tab) is VERY slow (2+ minutes for a list of around 200 combinations.)
I suspect that maybe an index has been dropped or something...?
I've used a SQL tracer and can see that this query is being executed LOTS of times:
SELECT
[Extent1].[Id] AS [Id],
[Extent1].[ProductId] AS [ProductId],
[Extent1].[ProductAttributeId] AS [ProductAttributeId],
[Extent1].[TextPrompt] AS [TextPrompt],
[Extent1].[IsRequired] AS [IsRequired],
[Extent1].[AttributeControlTypeId] AS [AttributeControlTypeId],
[Extent1].[DisplayOrder] AS [DisplayOrder]
FROM [dbo].[Product_ProductAttribute_Mapping] AS [Extent1]
WHERE [Extent1].[Id] IN (2199, 2206)
Obviously, when this attribute list is being populated in the backend, the product page on the frontend will not load until the backend query has completed (which could take several minutes), so this looks like a fairly big bug.
Are you able to suggest a quick fix (change of DB indexes, etc), so that I can continue to test this new version?
Thanks,
Nick