X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fsearch.rebuild_db.php;h=7e35247573f6f1b13f2d7393025c0d8d66bc5e4d;hb=c1ecaa25f3744989c83d6b552d2e9247db9c2f48;hp=cd7e56c9335dbc9429ab88010c8a13101823080f;hpb=0073747ac81cc9cff9e43847eb008f0e815255f0;p=platal.git

diff --git a/bin/search.rebuild_db.php b/bin/search.rebuild_db.php
index cd7e56c..7e35247 100755
--- a/bin/search.rebuild_db.php
+++ b/bin/search.rebuild_db.php
@@ -20,18 +20,28 @@
  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  ***************************************************************************/
 
-require('./connect.db.inc.php');
+require './connect.db.inc.php';
 
-ini_set('memory_limit', "16M");
+ini_set('memory_limit', '16M');
 $globals->debug = 0; // Do not store backtraces
 
 $res = XDB::iterRow('SELECT  pid
                        FROM  profiles');
 $i = 0;
 $n = $res->total();
-while ($pid = $res->next()->fetchOneCell()) {
-    Profile::rebuildSearchTokens($pid);
-    printf("\r%u / %u",  ++$i, $n);
+$pids = array();
+while ($pid = $res->next()) {
+    $pids[] = intval($pid[0]);
+    ++$i;
+    if (count($pids) == 100) {
+        Profile::rebuildSearchTokens($pids);
+        printf("\r%u / %u",  $i, $n);
+        $pids = array();
+    }
+}
+if (count($pids) > 0) {
+    Profile::rebuildSearchTokens($pids);
+    printf("\r%u / %u",  $i, $n);
 }
 
 print "done\n";