NopCommerce 4.10 - High memory usage and how we've handled it

Hi,

in version 4.0 I don't find Nop.Web.runtimeconfig.json file.

Where I can set  GarbageCollection to false ?

thanks

Wow, it don't work at all.

265 product and it take more then 3 minutes to load on a2hosting

Idea to Improve speed.

My nop 2.8 That I modified 5 years ago is still lighning vs Nop 4.1

Nop 2.8 500 products page:  http://www.sdvariations.com/1-voie?recordsPerPage=1000&page=1  loading time: 0.4 sec

Nop 4.1 https://nirvanagate.com 265 products page:
https://nirvanagate.com/all-nirvana-published

Loading time more then 2 minutes

This is not acceptable with a product that is mature and solid like NopCommerce 4.10

Your team are winner. You can solve this once and for all.

Here is the idea: Pre-formated data like I did on sdvariations.com it's better then caching

Everytime I add product into category I create a xml file just for this category listing with all information needed:  Name, short description, in the 2 languages Price, tier price divided by roles.

So I skip all request for the nop database.

But xml in the file system is not the best.

So since I don't code anymore here is my suggestion:

In admin category page when all products are added, I would put another button call: Pre-Format category.

Once you click it:

Option 1
it would create the xml and put it into a table call: Category_Manufacturer_Product_List

Field needed: Id-Type - Name - xml

Type is 2 choice: 1- category 2-Manufacturer

xml:  Have all the xml file in it


Option 2 create a table with all the xml field in it, the name of the table would be the category or the manufacturer name.

Anyway if a customer click on a category it would do JUST ONE REQUEST to the database.

If you need it, I can send you one of the xml file.

Also the button can be replace by a trigger that detect that a new products has been added into a category or into a manufacturer and start update of xml or table of prefomatted data.

Regards, Bruce OBrien

Please reply to me I need to know if I update my customer to 4.10.

gbsmtl wrote:

I would request you to have look at https://www.nopaccelerate.com/

It has nice integration with Apache Solr.

Well thank you,

But the goal is not to patch Nopcommerce with something else. The goal is to have a performing stand alone nopcommerce. If I have to pay 500$ to make something work normal it is non sense. I prefer give 500$ to nop team that worked so much for there product.

So I have the same question, Pre formating data to gain speed is a good idea like you can see in here: sdvariations.com.   Can NopCommerce team fix speed issue once and for all futur version?

Rergards,

Bruce

Maybe the problem in EF Core 2.10 bug.
https://github.com/aspnet/EntityFrameworkCore/issues/12451

I did plugin for fixing it
https://www.foxnetsoft.com/nopperformancefixefcore

Can you try and write here about result?

Before I try it 2 question:

1- do you think it's really going to improve page load speed?
2- If I want to remove is it easy or I have to re-install nop core?


Thank you

Regards, Bruce

>1- do you think it's really going to improve page load speed?
Yes. I am sure.
Try it free.
Copy this plugin in Plugins folder and restart your site.
You needn't install plugin. Plugin will start to work without installing.
Plugin will work trial period 15 days.

>2- If I want to remove is it easy or I have to re-install nop core?
Remove plugin from the folder. And restart your site.
You needn't change the nopcommerce kernel.

Please try and write me about result.

foxnetsoft wrote:
Thanks. We've also made a new branch fixing this issue. Please find the commit here. It could be helpful for developers who can apply it manually

Thank you Andrei.
Add such comment to the second topic too.

For developers.
It's better to add this fix in nopcommerce kernel (recompile nopcommerce kernel DLL).
My plugin solves the problem only for NopCommerce DBContext.
But external plugins can use own DBContexts.
I understand that external plugins don't use Lazy Loading often but.... it's better to recompile nopcommerce kernel DLL.