From ecbb32925e7b78cf41bca65c53a27bf68d598813 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 5 Aug 2015 16:58:07 +0300 Subject: [PATCH] gen-search-idx: more conservative batch handling --- update.php | 19 ++++++++----------- 1 file changed, 8 insertions(+), 11 deletions(-) diff --git a/update.php b/update.php index 8a00cdd5..216a9c1f 100755 --- a/update.php +++ b/update.php @@ -346,24 +346,21 @@ while (true) { $result = db_query("SELECT id, title, content FROM ttrss_entries WHERE tsvector_combined IS NULL ORDER BY id LIMIT $limit"); - if (db_num_rows($result) != 0) { - while ($line = db_fetch_assoc($result)) { - $tsvector_combined = db_escape_string(mb_substr($line['title'] . ' ' . strip_tags($line['content']), - 0, 1000000)); + while ($line = db_fetch_assoc($result)) { + $tsvector_combined = db_escape_string(mb_substr($line['title'] . ' ' . strip_tags($line['content']), + 0, 1000000)); - db_query("UPDATE ttrss_entries SET tsvector_combined = to_tsvector('english', '$tsvector_combined') WHERE id = " . $line["id"]); - } + db_query("UPDATE ttrss_entries SET tsvector_combined = to_tsvector('english', '$tsvector_combined') WHERE id = " . $line["id"]); + } - $processed += db_num_rows($result); - print "Processed $processed articles...\n"; + $processed += db_num_rows($result); + print "Processed $processed articles...\n"; - } else { + if (db_num_rows($result) != $limit) { echo "All done.\n"; break; } - } - } if (isset($options["list-plugins"])) { -- 2.39.5