Sniff I helped too Malte :( :(
Just kidding ...
I agree with the comment about removing the REPLY if the presentation's flat, along with the post number etc. We need to fix preview of course. Dave, when will we get to see that css, it looks like it's not set at the moment?
I changed the front page query to group recent posts by forum name, looks more sensible IMO and it's still fast.
And of course Dave needs to remember to add the STABLE attribute to the offending ETP PL/pgSQL procs so all sites, not just openacs.org, can be nice and fast without using magic object numbers :)
I have figured out, finally, how to make pagination in the list builder 1) continue to use the paginator 2) to not require any changes to existing client code and 3) to STILL BE ROCKIN' FAST and to have the slowest of the two needed queries to display a page be cachable. Plan to implement it in the next day or two.