4 ms·
I'd love a chronological feed but if you gave me a choice I'd get rid of lists in SQL first. > select * from posts where author_id in @follow_ids order by date
by mulmen 2y ago
I'd love a chronological feed but if you gave me a choice I'd get rid of lists in SQL first.
> select * from posts where author_id in @follow_ids order by date desc
SELECT post
FROM posts
JOIN follows
ON posts.author_id = follows.author_id
WHERE follows.user_id = $session.user_id;