Re: topic query count in alpha 1.0 – any progress?
I’m not exactly sure what you mean. There comes a point where we can’t reduce query count any further without resorting to complex joins, and to allow ourselves flexibility we need to avoid those. Caching solutions prefer simple queries and 1.0 has much better caching capabilities thanks to the use of the object cache functions in BackPress.
Also take a look at the WordPress memcached plugin, which is a drop-in replacement for the BackPress object cache functions and class, which hooks into a memcache server.
MySQL query caching should alleviate most speed problems though.