From da2349bb6a85d13f0aa29046bef3021cf0c884ba Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Thu, 12 Feb 2015 17:45:25 -0800
Subject: provide relief to sites that are severely impacted by the slow
 ITEM_UNSEEN searches. This does not incorporate any other flag optimisations
 as that will require a major DB update and possibly involve significant
 downtime. This is just to bite off a little chunk now and provide some much
 needed relief.

---
 mod/home.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'mod/home.php')

diff --git a/mod/home.php b/mod/home.php
index 854e2df26..db4ae9c42 100644
--- a/mod/home.php
+++ b/mod/home.php
@@ -170,7 +170,7 @@ function home_content(&$a, $update = 0, $load = false) {
 
 			$page_mode = 'list';
 
-			$simple_update = (($update) ? " and ( item.item_flags & " . intval(ITEM_UNSEEN) . " ) > 0 " : '');
+			$simple_update = (($update) ? " and item.item_unseen = 1 " : '');
 
 			if($update && $_SESSION['loadtime'])
 				$simple_update .= " and item.changed > '" . datetime_convert('UTC','UTC',$_SESSION['loadtime']) . "' ";
-- 
cgit v1.2.3