Testing TB

[nickz]

The presta forum has an interesting post on memory usage per visitor. 

https://www.prestashop.com/forums/topic/1097771-very-large-catalog-34-million-products-solved/

Posted by J. Jackson

Quote

Any software which fires 450 queries at the database server and consumes 1.5GB of RAM per visitor to display a product detail page has flaws that storage performance and database configuration tweaks won't solve. This was the results of the profiling done against the default install of PrestaShop with their catalog loaded. I submitted a pull request to deal with some of the initial memory issues I ran into,

and 

 

Quote

Just fyi - the "Recently Viewed" module fetches the entire list of product ID's (no filters involved) into RAM 3 times and does a for-loop style walk through looking for matching ID's from the cookies. This is the memory flaw I mentioned and uses an undue amount of CPU time. With 3.4MM items, this required upwards of 1.5GB of RAM per visitor to display a list of a half dozen recently viewed items. Thanks to bot traffic these days, it is not uncommon to have dozens of simultaneous requests being made against the site which offer little to no return value.

 

Who has done testing ? 
I don't use recently viewed as those a counterproductive in sales. 

[the.rampage.rado]

You know our module is completely different from theirs, right? The version we have is long archived and not used in PS.

[wakabayashi]

The thread in prestashop forum is quite interesting. I am now with 50k of products and notice here and there some performance issues. But these are almost always issues on my own code. With 3.4 million products you will find even much more such stuff. But these issues are often not relevant, if you have only 1k products.

In my expierence the perfomance issues came to 90% from modules and maybe 10% from bad hardware or missconfiguration.

What is the name of the corresponding thirtybees module? 

Edited Thursday at 09:40 AM by wakabayashi

[Yabber]

41 minutes ago, wakabayashi said:

What is the name of the corresponding thirtybees module? 

https://github.com/thirtybees/blockviewed

It also collects product data from cookies.

After all, this module has no value for customers, so why install it in the store?

[wakabayashi]

1 hour ago, Yabber said:

https://github.com/thirtybees/blockviewed

It also collects product data from cookies.

After all, this module has no value for customers, so why install it in the store?

Thanks! Github search sucks. I search there for "view" it doesn't show the "blockviewd" repository...

I looked only 5 minutes in the code, but it looks sensible. I see, that tb is reading the cookie and afterwards loading the needed products.

[nickz]

18 hours ago, the.rampage.rado said:

You know our module is completely different from theirs, right? The version we have is long archived and not used in PS.

Actually I did not. Thx for the Info. Its quite positive.
Unfortunately TB is hesitating in regards to promotion. A review so it seems is all TB needs.

Edited Thursday at 05:30 PM by nickz