SearchProductsAsync loading all data then applying pagging

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
1 ano atrás
So, if any category has the 5k product with attributes it will load the all 5k data in memory and then do the paging!!!!!!! and it is ok, right?
Md. Abu Sina

skype: live:.cid.c72238814ad795f9
whatsapp: +8801683715481
email: [email protected]
so : https://stackoverflow.com/users/1657994/sina-islam
-1
1 ano atrás
"SearchProductsAsync" method does not load all records in memory. It generates one single SQL command (including paging) that is executed only once.

You can check it with SQL Server profiler
Interested in the dedicated Premium support services provided by core developers? Please visit https://www.nopcommerce.com/nopcommerce-premium-support-services

Regards,
Andrei Mazulnitsyn
nopCommerce team
1
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.