[lazytown]

OK I tested the new version.

While it does reduce the number of queries, it still appears to at least double (or in some cases triple) the load created per thread page view. Now if the page is cached, the load increase is much smaller. However, if the page is not cached, the load increase is 2-3X. (mine went from about .35 sec per uncached page to about 1.0 sec per uncached page.) This was while almost no one was on the forum.

When testing, you have to try loading up old threads that are likely not in the cache. You also have to try a different thread each time, because once you load an old thread, it goes right into the cache. That is why testing load time increases can be difficult/confusing.

Thanks for the effort, but I had to remove it due to the load. As I mentioned earlier, I think the only way this could work for large forums is to create a table which would be a lot of work. It's a shame becase I think this is sorely needed (would also be nice to see posts per forum in the member profile, etc).

Thanks again.

-vissa