search

oc-shopaholic / oc-shopaholic-plugin

🛍️ No. 1 e-commerce platform for October CMS
https://shopaholic.one
GNU General Public License v3.0
426 stars 51 forks source link

ProductList performance issue #329

Open davidprovaznikj opened 3 years ago

davidprovaznikj commented 3 years ago

Hello, I have performance issue with getting productList data. Specifically this part of code: {% set obProductList = ProductList.make().active().category(obCategory.id) %}

If data didn't cached, this part of code make 260s delay to build the page. I tried delete all relations between product and category by backend admin. Now product is uncategorized, but still rendering page running 260s delay.

After generate cache saved to redis, performance issue dissapear.

My catalog is large: 250k products 307k offers 3 070 000 prices levels (lovata_shopaholic_prices db table)

Any advice? Thank you.

kharanenka commented 3 years ago

Hi! We are currently testing adding caching logic immediately after changes. This will give you availability not to run script that updates the cache.

Can you give us access to your project to debug the performance?

kdzone commented 3 years ago

One of the reasons: https://github.com/oc-shopaholic/oc-shopaholic-plugin/issues/253