From d2b5bb843fd3f0d464d8247d2be8c7d5ac9f534d Mon Sep 17 00:00:00 2001 From: friendica Date: Thu, 17 Apr 2014 22:06:35 -0700 Subject: more optimisations for discovery mode of zotfeed --- include/items.php | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'include/items.php') diff --git a/include/items.php b/include/items.php index a0a698836..8df090e0b 100755 --- a/include/items.php +++ b/include/items.php @@ -3855,10 +3855,11 @@ function zot_feed($uid,$observer_xchan,$mindate) { if($r) { $parents_str = ids_to_querystr($r,'parent'); - + $sys_query = ((is_sys_channel($uid)) ? $sql_extra : ''); + $items = q("SELECT `item`.*, `item`.`id` AS `item_id` FROM `item` WHERE `item`.`item_restrict` = 0 - AND `item`.`parent` IN ( %s ) ", + AND `item`.`parent` IN ( %s ) $sys_query ", dbesc($parents_str) ); } @@ -3873,6 +3874,9 @@ function zot_feed($uid,$observer_xchan,$mindate) { else $items = array(); + + logger('zot_feed: number items: ' . count($items),LOGGER_DEBUG); + foreach($items as $item) $result[] = encode_item($item); -- cgit v1.2.3