--- a/Command/ReorderTagsCommand.php	Thu Nov 17 16:48:19 2011 +0100
+++ b/Command/ReorderTagsCommand.php	Fri Nov 18 17:42:18 2011 +0100
@@ -54,6 +54,7 @@
         
         $done = 0;
         $iterable = $query->iterate();
+        $doctrine->getEntityManager()->beginTransaction();
         while (($row = $iterable->next()) !== false)
         {
             $done++;
@@ -70,13 +71,16 @@
             if($done%100 == 0)
             {
                 $doctrine->getEntityManager()->flush();
+                $doctrine->getEntityManager()->commit();
                 $doctrine->getEntityManager()->clear();
-                $todetach = array();
                 $output->writeln("memory : ".strval(memory_get_usage(true)));
+                $doctrine->getEntityManager()->beginTransaction();
             }
             
         }
         
+        $doctrine->getEntityManager()->commit();
+        
     }
 
 }