ProductValidityConsole 'product:check-validity'

KFrw
KFrw Developer Posts: 7 🧑🏻‍🚀 - Cadet
in Spryker Development 
public function queryProductsBecomingValid(): SpyProductValidityQuery
{
    return $this
        ->getFactory()
        ->createProductValidityQuery()
        ->filterByValidFrom('now', Criteria::LESS_EQUAL)
        ->filterByValidTo(null, Criteria::ISNULL)
        ->_or()
        ->filterByValidTo('now', Criteria::GREATER_EQUAL);
}

So this selects all products in the end by two queries and kills our system with an OOM…

I guess we now move this to pagination or a queue.

Any other ideas about that?

Categories