X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fsearch.rebuild_db.php;h=7e35247573f6f1b13f2d7393025c0d8d66bc5e4d;hb=c1ecaa25f3744989c83d6b552d2e9247db9c2f48;hp=1b9917ff5d1a18266978174db05dd43f1e627cea;hpb=96d80a35f4abef2b94d2f2b8f5442230141398d1;p=platal.git diff --git a/bin/search.rebuild_db.php b/bin/search.rebuild_db.php index 1b9917f..7e35247 100755 --- a/bin/search.rebuild_db.php +++ b/bin/search.rebuild_db.php @@ -1,7 +1,7 @@ #!/usr/bin/php5 -q debug = 0; // Do not store backtraces -$res = XDB::iterRow("SELECT user_id - FROM auth_user_md5"); +$res = XDB::iterRow('SELECT pid + FROM profiles'); $i = 0; $n = $res->total(); -while ($uid = $res->next()->fetchOneCell()) { - user_reindex($uid); - 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";