[]Omegatron said:
So far no. The link is correct but all the ways people have come up with can kill servers as it would have to scan the entire post table to get the true lastpost. That is in essense what I did to get it to truly work. I added a left join on the post table to scan again and compare and get the last post but as you saw that on busier sites was a killer. [/]
ya, this is the killer I am running up against. My users absolutly love the last post thing, but you are right, it is killing my board. I'm going to try without a preview for a few days and see how it works.
I guess the other thing to do would be to have a cron drive a query and update a table every 5 minutes with the proper data and just have it retrieved from there.
Fred