DecimalRowSizeEstimator.php

Go to the documentation of this file.

<?php
namespace Magento\Catalog\Model\ResourceModel\Product\Indexer\Eav;

use Magento\Store\Api\StoreManagementInterface;
use Magento\Framework\Indexer\IndexTableRowSizeEstimatorInterface;
use Magento\Framework\EntityManager\MetadataPool;
use Magento\Catalog\Api\Data\ProductInterface;

class DecimalRowSizeEstimator implements IndexTableRowSizeEstimatorInterface
{
    private $indexerResource;

    private $storeManagement;

    private $metadataPool;

    public function __construct(
        StoreManagementInterface $storeManagement,
        Decimal $indexerResource,
        MetadataPool $metadataPool
    ) {
        $this->storeManagement = $storeManagement;
        $this->indexerResource = $indexerResource;
        $this->metadataPool = $metadataPool;
    }

    public function estimateRowSize()
    {
        $connection = $this->indexerResource->getConnection();
        $entityIdField = $this->metadataPool->getMetadata(ProductInterface::class)->getLinkField();

        $valueSelect = $connection->select();
        $valueSelect->from(
            ['value_table' => $this->indexerResource->getTable('catalog_product_entity_decimal')],
            ['count' => new \Zend_Db_Expr('count(value_table.value_id)')]
        );
        $valueSelect->group([$entityIdField, 'store_id']);

        $maxSelect = $connection->select();
        $maxSelect->from(
            ['max_value' => $valueSelect],
            ['count' => new \Zend_Db_Expr('MAX(count)')]
        );
        $maxRowsPerStore = $connection->fetchOne($maxSelect);

        return ceil($maxRowsPerStore * $this->storeManagement->getCount() * 500);
    }
}