Random products on 1.5

[cemas]

Hi, i found several mods how to make home featured products to show randomly, but it not working normally, products are shown with blank spaces. Maybe anyone knows how to make it on ps 1.5?

[cemas]

anyone?

[doekia]

I recommend not to use any random alike modules/mods with your shops unless you have less than a few products.

The infamous ORDER BY RAND() is a performance killer.

 

Now if you get weird layout, check cache, tpls, carriage return after the '?>' closing tag and the like.

[cemas]

Hi, i need to randomize from all products not from featured only. I used this code:

$nb1 = 20;

$products = $category->getProducts((int)($params['cookie']->id_lang), 1, ($nb1 ? $nb1 : 10));

if ($products) { shuffle($products); array_splice($products, ($nb ? $nb : 10)); }

 

but it randomize only from featured not from all products and it shows products badly:

[doekia]

Exactly what I mean about performance killing code.

 

When we want to get a random set (w/ or w/o feature) we do something like:

select x,y,z

from t

order by rand()

limit n;

 

This add a pseudo column to the select then order it by this pseudo (random) column and finaly extract just the n first elements.

 

The more product you have, the more the bubble sort based on the pseudo column will have to work and this computation tend to be exponential. I usually address randomization thru a set of scheduled database creation of subset but this is nothing Prestashop standard and requires some privileges that may not be available depending on your hoster.