This is driving me crazy. Hopefully someone can help. I'm parsing a
large file and saving that data to a database. My script is quickly
consuming all available memory. I upped the PHP memory limit to 1GB
but this is a hack. I've narrowed the problem down to the model's
cacheQueries setting. It appears to have no effect whatsoever. If I
however use the query() method directly of a model, the memory usage
remains low and constant.
Here's part of my code that being run in a loop as part of a shell
(console):
The "MasterIssue" class has no related models.
$this->MasterIssue->cacheQueries = false;
// This causes memory issues!!!
$issues = $this->MasterIssue->find('all', array(
'conditions' => array('MasterIssue.cusip LIKE' => $cusip_prefix .
'%'),
'fields' => array('MasterIssue.id', 'MasterIssue.cusip')
));
// This does NOT cause memory issues
//$issues = $this->MasterIssue->query("SELECT * FROM master_issues
WHERE cusip LIKE '$cusip_prefix%'", false);
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
