Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 1.2.2
-
Fix Version/s: None
-
Component/s: Searchable
-
Labels:None
-
Environment:php5.3.2, mysql 5.1, centos 5
Description
batchUpdateIndex leaks memory when indexing a table
I'm using Doctrine 1.2.2 with Symfony 1.4.7-dev ( both latest from Symfony svn).
I have table with approx ~300 000 rows.
Doctrine::getTable('sfVideo')->batchUpdateIndex(); running this command will end after ~10 seconds.
Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 71 bytes) in /usr/share/symfony/1.4/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php on line 800
Memory is leaking constantly even if using offset and limit.
Doctrine::getTable('sfVideo')->batchUpdateIndex(10000, 25000);