Show more threads?

May 16, 2001 8:12 AM

Would it be feasible to increase the number of threads that appear with the "recent comments" feature? rodii made the point the other day that as the volume of posts has increased, threads fall below #20 pretty quickly and tend to die sooner than they may have in the past. If recent comments were completely chronological with no limitation by original thread date, it might result in fewer double posts.
posted by gimli to Feature Requests at 8:12 AM (6 comments total)

rodii's comment. As usual, much more eloquent than me.
posted by gimli at 8:15 AM on May 16, 2001

I knew if I waited long enough you'd do this for me, gimli. :)
posted by rodii at 1:43 PM on May 16, 2001

I don't presume to speak for Matt, but when we added that feature we chose 20 threads simply to reduce the load on the server. It is kind of an expensive query, so we didn't want to return a large recordset. Since then, however, I have discovered that including a "top" clause in the SQL is actually more proc intensive than leaving it out. Maybe we can experiment with differnet ways of increasing this number Matt?
posted by ericost at 5:36 PM on May 16, 2001

Maybe we can experiment with differnet ways of increasing this number Matt?

Like based on the number of posts in the last 15 or 30 minutes?

posted by ParisParamus at 7:32 PM on May 16, 2001

eric, I still have the "next 20 recent comments" query commented out (which I could write to the page).

I agree the "top" queries are pretty gnarly on SQL server (we found this out at pyra).
posted by mathowie (staff) at 8:14 PM on May 16, 2001

Does this have to be generated every time someone hits the main page? Can it be done every so often (like, once per minute) and cached? (Slap me if this is an ignorant question, I don't really know what's involved.)
posted by rodii at 8:35 PM on May 16, 2001