[Forum] Does it matter - technically - if a thread is endless? Going past 10,000 posts?

[Mary303]

As of this moment, 10,565 posts and counting. Is there a reason this length would interfere with anyone's ability to access the end page? The whole thread doesn't load, does it, just the requested page?

Can have it carry on in a new thread if advisable - but if it doesn't matter, it can stay as it is.

thx!

[FractalizeR]

It matters a little.

SELECT post.postid
FROM " . TABLE_PREFIX . "post AS post
$hook_query_joins
WHERE post.threadid = $threadid
AND post.visible = 1
" . ($coventry ? "AND post.userid NOT IN ($coventry)" : '') . "
$hook_query_where
ORDER BY post.dateline $postorder
LIMIT $limitlower, $perpage

This query to select even just postids becomes slower with the number of posts in the thread because of it's LIMIT part.

[CK]

I'm confused here,what's the issue with long threads?

[Mary303]

It matters a little.


This query to select even just postids becomes slower with the number of posts in the thread because of it's LIMIT part.

Thanks for the info - I wish I knew what you are talking about. What function is this query? Thank you.