diff options
author | Andrew Dolgov <[email protected]> | 2015-08-05 16:58:07 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2015-08-05 16:58:07 +0300 |
commit | ecbb32925e7b78cf41bca65c53a27bf68d598813 (patch) | |
tree | 0575d3fdc499d5aafa562575c63c99a9a058d016 | |
parent | c7edba791c69565afa89a5e2c6e90e82d525d509 (diff) |
gen-search-idx: more conservative batch handling
-rwxr-xr-x | update.php | 19 |
1 files changed, 8 insertions, 11 deletions
diff --git a/update.php b/update.php index 8a00cdd55..216a9c1f4 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"])) { |