add tag cache for user_entries (bump schema)

[tt-rss.git] / functions.php

diff --git a/functions.php b/functions.php
index 5e7b7c20f513ab343d4597bc75bc89fcb92237dd..c4d033bc20a653cdb3a0ef198a06b4ee77a447cf 100644 (file)
--- a/functions.php
+++ b/functions.php
@@ -1199,9 +1199,9 @@
                                                $result = db_query($link,
                                                        "INSERT INTO ttrss_user_entries 
                                                                (ref_id, owner_uid, feed_id, unread, last_read, marked, 
-                                                                       published, score) 
+                                                                       published, score, tag_cache) 
                                                        VALUES ('$ref_id', '$owner_uid', '$feed', $unread,
-                                                               $last_read_qpart, $marked, $published, '$score')");
+                                                               $last_read_qpart, $marked, $published, '$score', '')");
 
                                                $result = db_query($link, 
                                                        "SELECT int_id FROM ttrss_user_entries WHERE
@@ -1433,6 +1433,14 @@
                                                                        (owner_uid,tag_name,post_int_id)
                                                                        VALUES ('$owner_uid','$tag', '$entry_int_id')");
                                                        }                                                       
+
+                                                       /* update the cache */
+
+                                                       $tags_str = db_escape_string(join(",", $filtered_tags));
+
+                                                       db_query($link, "UPDATE ttrss_user_entries 
+                                                               SET tag_cache = '$tags_str' WHERE ref_id = '$entry_ref_id'
+                                                               AND owner_uid = $owner_uid");
                                                }
 
                                        db_query($link, "COMMIT");
@@ -4660,10 +4668,32 @@
                if ($memcache && $obj = $memcache->get($obj_id)) {
                        $tags = $obj;
                } else {
-                       $tmp_result = db_query($link, $query);
+                       /* check cache first */
+
+                       $result = db_query($link, "SELECT tag_cache FROM ttrss_user_entries
+                               WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]);
+
+                       $tag_cache = db_fetch_result($result, 0, "tag_cache");
+
+                       if ($tag_cache) {
+                               $tags = explode(",", $tag_cache);
+                       } else {
 
-                       while ($tmp_line = db_fetch_assoc($tmp_result)) {
-                               array_push($tags, $tmp_line["tag_name"]);                               
+                               /* do it the hard way */
+
+                               $tmp_result = db_query($link, $query);
+
+                               while ($tmp_line = db_fetch_assoc($tmp_result)) {
+                                       array_push($tags, $tmp_line["tag_name"]);                               
+                               }
+
+                               /* update the cache */
+
+                               $tags_str = db_escape_string(join(",", $tags));
+
+                               db_query($link, "UPDATE ttrss_user_entries 
+                                       SET tag_cache = '$tags_str' WHERE ref_id = '$id'
+                                       AND owner_uid = " . $_SESSION["uid"]);
                        }
 
                        if ($memcache) $memcache->add($obj_id, $tags, 0, 3600);