2.0 bugs

hey guys

i did the upgrade move from 1.9 to 2.0
just perfect

but ....

when you click on settimgs - catalog - Show the number of distinct products besides each category
the website dies
the response slows down significantly and performance is rduced by 90 %

let me know if this is solved somehow
thanks

Agree, it's slow. This option was also slow in the previoius versions (that's why it's disabled by default). Some performation optimization is required.

Yes, I reported this during beta.  See this
https://www.nopcommerce.com/boards/t/10624/20-speedperformance-concerns.aspx?p=8

I recommended creating an index there

Associated with Release: nopcommerce 2.20.

Error when selecting this option:
Show the number of distinct products besides each category

//database call
                    var reader = cmd.ExecuteReader();
                    //return reader.DataReaderToObjectList<TEntity>();
                    var result = context.Translate<TEntity>(reader).ToList();
                    foreach (var entity in result)
Error ==>     Set<TEntity>().Attach(entity);
                    //close up the reader, we're done saving results
                    reader.Close();
                    return result;


An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key.

Error ==>    @Html.Action("CategoryNavigation", "Catalog", new { currentCategoryId = currentCategoryId })

see
https://www.nopcommerce.com/boards/t/12404/22-exception-when-showing-number-of-products-besides-each-category.aspx

Any solution to this problem yet? It really needs to be optimized.