Hi @padmachhat5f0d ,
When Magento’s “Customer Credit Report” grid tries to load 127538 customer-balance rows all in one go, it’s not at all surprising that PHP ends up chewing through tens or even hundreds of megabytes of Random Access Memory - especially if export‐to‐CSV is triggered, which pulls the entire collection into memory.
If upping PHP’s memory still isn’t enough (or you’d rather not throw hardware at the problem), you can customize the credit-report grid so that it:
Paginates the export rather than loading the full collection at once
Streams rows into CSV in batches, e.g.
$batchSize = 500;
$currentPage = 1;
$collection = $this->collectionFactory->create();
$collection->setPageSize($batchSize);
do {
$collection->setCurPage($currentPage++);
foreach ($collection as $item) {
// write $item to CSV file
}
$collection->clear(); // free memory
} while ($currentPage <= $collection->getLastPageNumber());You could override the export action in your own module to implement chunked exporting instead of the default load-everything approach.
Run a cron job or CLI task for large exports
If your users only occasionally need the CSV, consider:
Writing a small shell script or Symfony Console command that generates the credit-report CSV with unlimited memory
Scheduling it via cron so that it runs during off-peak hours and places the file on the server or emails it to the user
That way, the Admin UI never has to bear the full memory burden itself.
Problem Solved? Accept as Solution!
Thanks,
Ankit
Ankit Jasani
