When i was doing mass status change in magento
I was facing with memory allocation in my localshot xammp
Total products i have around 7lakh in the admin grid. i tried to change the status about to 100 products,
i got this error
Fatal error: Allowed memory size of 805306368 bytes exhausted (tried to allocate 24 bytes) in C:\xampp\htdocs\mage-ee206\vendor\magento\zendframework1\library\Zend\Db\Statement\Pdo.php on line 291
==============
After spending one day time i got the solution
In one of my third party i found a iteration of products using foreach.. when i changed foreach to while it worked fine for me
i have tested for 30,50,100,500,700 products to changes the status and it was fine for me
I hope this may help you
original code
$Prods = $this->_productFactory->create()->getCollection()->addIdFilter(<prodids>);
$Prods->addAttributeToSelect(['status','<status>']);
foreach ($Prods as $prod) {
$prodid = $prod->getId();
$prod_status = $prod->getData('status');
=======================
Changed to
$Prods = $this->_productFactory->create()->getCollection()->addIdFilter(<prodids>);
$Prods->addAttributeToSelect(['status','<status>']);
while ($prod = $Prods->fetchItem()) {
$prodid = $prod->getId();
$prod_status = $prod->getStatus();
============