Changeset 6824

Timestamp:

10/13/08 12:14:13 (3 months ago)

Author:

inureyes

Message:

refs #1110

• 알고리즘 수정. (속도 개선)
  
• TODO : 리더에 등록된 피드에 따라 메모리를 무지하게 잡수시는 방법이다. 메모리 문제를 어떻게 해결할 것인가?
  

Files:

• trunk/library/model/reader.common.php (modified) (1 diff)

trunk/library/model/reader.common.php

@@ -43 +43 @@
         WHERE blogid = $blogid");
     if(isset($registeredFeeds)) {
-        foreach($registeredFeeds as $feed) {
-            $feedItems = POD::queryColumn("SELECT id from {$database['prefix']}FeedItems WHERE feed = $feed");
-            if(!empty($feedItems)) {
-                $readFeedItems = POD::queryColumn("SELECT item FROM {$database['prefix']}FeedReads
-                    WHERE blogid = $blogid");
-                $unreadFeedItems = array_diff($readFeedItems, $feedItems);
-                if(!empty($unreadFeedItems)) {
-                    foreach($unreadFeedItems as $item) {
-                        POD::execute("INSERT INTO {$database['prefix']}FeedReads (blogid, item) VALUES ($blogid, $item)");
-                    }
+        $feedItems = array();
+        foreach($registeredFeeds as $feed) {    /// Gather feed information 
+            $feedId = POD::queryColumn("SELECT id FROM {$database['prefix']}FeedItems WHERE feed = $feed");
+            if(!empty($feedId)) array_push($feedItems,$feedId);
+        }
+        if(!empty($feedItems)) {
+            $readFeedItems = POD::queryColumn("SELECT item FROM {$database['prefix']}FeedReads
+                WHERE blogid = $blogid");
+            $unreadFeedItems = array_diff($readFeedItems, $feedItems);
+            if(!empty($unreadFeedItems)) {
+                foreach($unreadFeedItems as $item) {
+                    POD::execute("INSERT INTO {$database['prefix']}FeedReads (blogid, item) VALUES ($blogid, $item)");
+                }
             
-                }
             }
         }