RowSizeEstimator.php

Go to the documentation of this file.

<?php
namespace Magento\Catalog\Model\Indexer\Category\Product;

use Magento\Framework\Indexer\IndexTableRowSizeEstimatorInterface;

class RowSizeEstimator implements IndexTableRowSizeEstimatorInterface
{
    const ROW_MEMORY_SIZE = 100;

    private $resourceConnection;

    public function __construct(
        \Magento\Framework\App\ResourceConnection $resourceConnection
    ) {
        $this->resourceConnection = $resourceConnection;
    }

    public function estimateRowSize()
    {
        $connection = $this->resourceConnection->getConnection();

        // get store groups count except the default
        $storeGroupSelect = $connection->select()
            ->from(
                $this->resourceConnection->getTableName('store_group'),
                ['count' => new \Zend_Db_Expr('count(*)')]
            )->where('group_id > 0');
        $storeGroupCount = $connection->fetchOne($storeGroupSelect);

        // get max possible categories per product
        // subselect with categories count per product
        $categoryCounterSubSelect = $connection->select()
            ->from(
                $this->resourceConnection->getTableName('catalog_category_product'),
                ['counter' => new \Zend_Db_Expr('count(category_id)')]
            )->group('product_id');

        // select maximum value from subselect
        $productCountSelect = $connection->select()
            ->from(
                ['counters' => $categoryCounterSubSelect],
                [new \Zend_Db_Expr('max(counter)')]
            );
        $maxProducts = $connection->fetchOne($productCountSelect);

        return ceil($storeGroupCount * $maxProducts * self::ROW_MEMORY_SIZE);
    }
}