pioneer

pioneer OP wrote (edited )

Just quickly got a look at the code (I'm no PHP dev, but can guess something). Are we talking about

SELECT * FROM comment ORDER BY timestamp;

vs

<subscribed forum ids> = SELECT forum_id FROM forum_subscription WHERE user_id = <current user id>;
<ids of submissions in subscribed forums> = SELECT id FROM submission WHERE forum_id IN (<subscribed forum ids>);
SELECT * FROM comment WHERE submission_id IN (<ids of submissions in subscribed forums>) ORDER BY timestamp;

?

Doesn't look too expensive for me, forgive me if I'm wrong. Though I don't take banned content into account, for example.

1