IT IS FIXED NOW! nopCommerce is flying!!!
Oh my god it is much faster now.
Before this fix - with only 125,000 orders and 70,000+ customer I could bring nopCommerce to use 8 Gigabyte of memory simply by opening through a few Adminstration pages. And these admistration pages would load in around 90 seconds.
Now with this fix - I can open pages in a few seconds. And nopCommerce only uses 600MB - it is an amazing difference.
It is going to save me a lot of money in server deployment - FANTASTIC.
To be honest - I dont think I could have deployed the app before - but now I have a lot more confidence I can.
Andrei - you owe me a big one on this one. A very big one.
I have never worked for free in my life - and to be honest my consulting fees are $250 per hour.
I had to give up my entire weekend to fix the performance issues of nopCommerce 3.8.
I think I just spent at least 20 hours this weekend just fixing all the performance issues I could find.
Don't get me wrong - I am very glad I did. What an amazing difference.
But the bugs I found are so massive - anyone should have been able to see it.
Anyhow - nopCommerce is flying now (compared to before)
I don't think I have ever seen such dramatic improvement for such simple coding mistake.
Life is good again. I will sleep very well tonight.
Can you share your new code with us. So that we can check that too and check the difference. :)