From 624196711242cb5bf398ff2d368e73a10e65b67e Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Mon, 20 Nov 2017 09:57:07 +0100 Subject: speed up initial query if no mid is provided --- Zotlabs/Module/Hq.php | 1 + 1 file changed, 1 insertion(+) (limited to 'Zotlabs') diff --git a/Zotlabs/Module/Hq.php b/Zotlabs/Module/Hq.php index 41e9d40ca..ad39768f4 100644 --- a/Zotlabs/Module/Hq.php +++ b/Zotlabs/Module/Hq.php @@ -46,6 +46,7 @@ class Hq extends \Zotlabs\Web\Controller { $r = q("SELECT mid FROM item WHERE uid = %d + AND item_unseen = 1 AND mid = parent_mid $item_normal ORDER BY id DESC -- cgit v1.2.3 From 66c0ac591cd342a31348ad54723fd269659251c6 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Mon, 20 Nov 2017 10:00:13 +0100 Subject: order by created instead of id --- Zotlabs/Module/Hq.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Zotlabs') diff --git a/Zotlabs/Module/Hq.php b/Zotlabs/Module/Hq.php index ad39768f4..e2efc6a0d 100644 --- a/Zotlabs/Module/Hq.php +++ b/Zotlabs/Module/Hq.php @@ -49,7 +49,7 @@ class Hq extends \Zotlabs\Web\Controller { AND item_unseen = 1 AND mid = parent_mid $item_normal - ORDER BY id DESC + ORDER BY created DESC limit 1", local_channel() ); -- cgit v1.2.3 From 9ab33f1e134e6e7694a42b92fc9d73c2e6dcffd1 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Mon, 20 Nov 2017 11:05:08 +0100 Subject: we need a mid also if there is no unseen items --- Zotlabs/Module/Hq.php | 1 - 1 file changed, 1 deletion(-) (limited to 'Zotlabs') diff --git a/Zotlabs/Module/Hq.php b/Zotlabs/Module/Hq.php index e2efc6a0d..92dfc8587 100644 --- a/Zotlabs/Module/Hq.php +++ b/Zotlabs/Module/Hq.php @@ -46,7 +46,6 @@ class Hq extends \Zotlabs\Web\Controller { $r = q("SELECT mid FROM item WHERE uid = %d - AND item_unseen = 1 AND mid = parent_mid $item_normal ORDER BY created DESC -- cgit v1.2.3