From ac7010914d71ee590db24a4ad2a1cb16664ba575 Mon Sep 17 00:00:00 2001 From: Adam Mathes Date: Sun, 22 Apr 2018 20:46:54 -0700 Subject: switch to straight / inner joins for speed, maybe --- models/item/item.go | 14 ++++++++++++-- 1 file changed, 12 insertions(+), 2 deletions(-) (limited to 'models') diff --git a/models/item/item.go b/models/item/item.go index 4d3f455..751cb2f 100644 --- a/models/item/item.go +++ b/models/item/item.go @@ -117,11 +117,21 @@ func Filter(max_id int64, feed_id int64, category string, unread_only bool, star var args []interface{} - query := `SELECT item.id, item.feed_id, item.title, item.url, item.description, + // INNER JOIN MACHINE GOOO + + // select STRAIGHT_JOIN item.*, feed.* + // FROM item + // INNER JOIN feed ON feed.id=item.feed_id + // WHERE item.read_state=false and feed.category='news' + // ORDER BY item.id desc + // LIMIT 15; + + query := `SELECT STRAIGHT_JOIN item.id, item.feed_id, item.title, item.url, item.description, item.read_state, item.starred, item.publish_date, item.full_content, item.header_image, feed.url, feed.title, feed.category - FROM item,feed + FROM item + INNER JOIN feed ON feed.id=item.feed_id WHERE item.feed_id=feed.id ` if max_id != 0 { -- cgit v1.2.3