我有一个foreach循环,正在读取包含大约200000行的文件,这是我的PHP代码:
foreach ($this->file as $row)
{
if ($this->file->valid())
{
//init client array
$this->initInvoicesArray($row);
$this->prepareInvoice();
$row = null;
$this->key = $this->file->key();
//add msisdn to msisdn array, and client to clients array
self::$MsisdnArray[] = $this->msisdn;
self::$InvoicesArray[$this->msisdn] = $this->client;
if ($i % 3000 == 0)
{
//get valid users from table
$this->prepareAndSaveValidClients();
}
$i++;
}
}
以下是prepareAndSaveValidClients()函数:
public function prepareAndSaveValidClients(){
$query = Doctrine_Query::create()
->select('p.gender, p.email2, u.username, u.first_name, u.last_name, u.email_address, u.is_active, p.msisdn, p.user_id, p.city_id, p.street, p.zipcode, p.msisdn_status')
->from('sfGuardUser u')
->innerJoin('u.Profile as p ON u.id = p.user_id')
->whereIn('p.msisdn', self::$MsisdnArray)
->whereIn('p.status', self::$AllowedStatus);
$results = $query->fetchArray();
//instanciat an object collection for payment_notifications
$collection = new Doctrine_Collection("payment_notifications");
if (!empty($results))
{
foreach ($results as $key => $client)
{
$invoice = self::$InvoicesArray[$client['Profile']['msisdn']];
$this->initInvoicesArray($invoice);
$this->prepareInvoice();
$this->prepareUserProfile($client);
$this->prepareClient();
$paymentNotifications = new paymentNotifications();
$paymentNotifications->fromArray($this->client);
$collection->add($paymentNotifications);
$tel = $client['Profile']['msisdn'];
$client = null;
}
$collection->save();
//clear memory
$results = null;
$collection = null;
self::$MsisdnArray = null;
self::$InvoicesArray = null;
$this->logSection('tel num', 'added :' . $tel . ' Memory usage : ' . memory_get_usage());
$duration = microtime(true) - $this->startTime;
$this->logSection('payment : ', sprintf('added in %s', $duration));
}
}
关于功能:
$this->initInvoicesArray($invoice);
$this->prepareInvoice();
$this->prepareUserProfile($client);
$this->prepareClient();
它们只是为了准备$this->client
这是每个循环所显示的内存使用情况:
>> tel num added :0699946185 Memory usage : 89287596
>> payment : added in 8.6373870372772
>> tel num added :0699983919 Memory usage : 165854544
>> payment : added in 18.373502969742
>> tel num added :0699949623 Memory usage : 241338788
>> payment : added in 29.336947917938
>> tel num added :0699854750 Memory usage : 319173092
>> payment : added in 40.880628824234
正如您所看到的,我试图释放这些变量的内存:
$results = null;
$collection = null;
self::$MsisdnArray = null;
self::$InvoicesArray = null;
但是徒劳无功,内存使用量在每次循环后都会增加,这导致了一个“允许的内存大小已用尽”的致命错误。我该如何进行优化?
谢谢。
$this->file = new SplFileObject($this->filePath, 'r');
$this->file->setFlags(SplFileObject::READ_CSV);
- SmootQ