Hi Daniel - do you use the profiler? If it's set to 'true' then it
will start accumulating SQL statements as a log and thereby increasing
the size of the adapter object.
Hello,
I wrote a cli script that updates about 23.000 records once a day.
But after several thousand records have been updated, the script
used more than 128mb of memory. I’m not quiet sure if it’s a
zend_db_table or php related issue.
I wrote a little test-script to reproduce the memory leak. I’m
running zf 1.0.2 and php 5.2.3 (cli / win32).
<?php
protected function indexAction ()
{
$playcom = new PlaycomItems(); // just one table that extends
Zend_Db_Table and sets the required $_name property
$limit = 10;
for($offset = 0; $offset < 10000; $offset += $limit) {
$rows = $playcom->fetchAll(null, 'id ASC', $limit, $offset);
echo memory_get_usage(true) . ' / ' .
memory_get_usage(false) . " bytes in use.\n";
unset($rows); // should not be necessary, but makes no
difference anyway
}
}
?>
The output looks like this:
4456448 / 4371232 bytes in use.
4456448 / 4374144 bytes in use.
4456448 / 4376784 bytes in use.
4456448 / 4378840 bytes in use.
4456448 / 4381504 bytes in use.
4718592 / 4384176 bytes in use.
4718592 / 4386832 bytes in use.
4718592 / 4389392 bytes in use.
4718592 / 4391976 bytes in use.
4718592 / 4394632 bytes in use.
4718592 / 4397192 bytes in use.
4718592 / 4399736 bytes in use.
4718592 / 4402408 bytes in use.
......
Any help is appreciated,
Daniel
--
Simon Mundy | Director | PEPTOLAB
""" " "" """""" "" "" """"""" " "" """"" " """"" " """""" "" "
202/258 Flinders Lane | Melbourne | Victoria | Australia | 3000
Voice +61 (0) 3 9654 4324 | Mobile 0438 046 061 | Fax +61 (0) 3 9654
4124
http://www.peptolab.com
