From 73ef6f0459883667f4459e4d7e165eb3e587bb9e Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 4 Aug 2015 14:36:39 +0300 Subject: [PATCH] gen-search-idx: do not rely on offsets --- update.php | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/update.php b/update.php index 5a082279..8a00cdd5 100755 --- a/update.php +++ b/update.php @@ -338,17 +338,15 @@ $result = db_query("SELECT COUNT(id) AS count FROM ttrss_entries WHERE tsvector_combined IS NULL"); $count = db_fetch_result($result, 0, "count"); - print "Entries to process: $count.\n"; + print "Articles to process: $count.\n"; - $offset = 0; - $limit = 1000; + $limit = 500; + $processed = 0; while (true) { - $result = db_query("SELECT id, title, content FROM ttrss_entries WHERE tsvector_combined IS NULL ORDER BY id LIMIT $limit OFFSET $offset"); + $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) { - echo "Offset $offset...\n"; - while ($line = db_fetch_assoc($result)) { $tsvector_combined = db_escape_string(mb_substr($line['title'] . ' ' . strip_tags($line['content']), 0, 1000000)); @@ -356,7 +354,9 @@ db_query("UPDATE ttrss_entries SET tsvector_combined = to_tsvector('english', '$tsvector_combined') WHERE id = " . $line["id"]); } - $offset += $limit; + $processed += db_num_rows($result); + print "Processed $processed articles...\n"; + } else { echo "All done.\n"; break; -- 2.39.2