Login takes 25 seconds up to a one minit.

Hi

Server: Intel XEON 2.40Ghz 4 Cores, 14GB memory
SQL Server 2016

Iv'e recently installed the 3.80 and added about 600 products to it.
Each product has it's own ProductAttributes and combinations, so generelly I have about 66.000 products.

When I try to login to the site it takes about 25sec to one minit to login.
When logged in the site is terribly slow.

Does any have or experienced this?
Does the login trigger any reload of attributes or other recources?

I've isolated the problem to the FlyoutShoppingCart.

If I remove the line in header.cshtml
Line:
@Html.Action("FlyoutShoppingCart", "ShoppingCart") it disapears.

Right now it's a disaster, it takes several minits to login.
My wildest gúess is that this function load all the products one more time(66000 Products with all the product combinations).

This is a bug in Nopcommerce.
This only happends when I'm logged in.

Does anyone know how to fix this? This is very urgent!

Bootproject wrote:
Sounds odd, but I wouldn't expect it to load all 66,000 product attribute combinations unless you have them all in your cart at once. Does it take that long if you empty the basket of the logged in user and then log out and back in again?

You could try debugging it and setting a breakpoint on the FlyoutShoppingCart method of the ShoppingCartController and see if you can determine why it's taking so long if you're sure that's where the problem is.

This problem only appears when I'm logged in as administrator.
If I login is a normal user, site function normally.

If I debug  the site, I'll see that it's loading all products.. (Queries(SQL) the database, ALL!!!!) It doesn't stop.

Hummm.
I created a new account, added my self a new administrator and the problem seems to gone a away.