Attribute generation long time 1.6.1.6

[DarekB]

Hello

I try understand why generator attribute is so long...?

 

for example if i have 4x4x4x5 combination = 320

 

When i run profilling: 

 

 

for all generation combination i have this query 

 

/classes/stock/StockAvailable.php:446

 

SELECT SQL_NO_CACHE SUM(quantity) as quantity

FROM tm_stock_available

WHERE id_product = 8

AND id_product_attribute <> 0  AND id_shop = 1  AND id_shop_group = 0 LIMIT 1

 

 

 

time : 183.1ms

 

 

4x4x4x5 * 180ms = 57,6secound

 

 

i try comment this total_quantity and set static total_quantity

 

/*  $total_quantity = (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('

SELECT SUM(quantity) as quantity

FROM '._DB_PREFIX_.'stock_available

WHERE id_product = '.(int)$this->id_product.'

AND id_product_attribute <> 0 '.

            StockAvailable::addSqlShopRestriction(null, $id_shop)

        );*/

        

        $total_quantity = 2000;

        $this->setQuantity($this->id_product, 0, $total_quantity, $id_shop);

 

 

 

this trick speed generation combination.

 

Why this sql query took too long ??? 180ms???

 

SELECT SQL_NO_CACHE SUM(quantity) as quantity

FROM tm_stock_available

WHERE id_product = 8

AND id_product_attribute <> 0  AND id_shop = 1  AND id_shop_group = 0 LIMIT 1

 

 

Thank you for any tips