Thanks Dave. Yes it's taking around 4.6 seconds, I am sure it can be improved further if I can get Scott (SCybak) to tweek the tables indexes. We ran all the tests at another site on Bravidio, which I know is a different server. The UA server always out performs the test site - shared, but less shares I guess!
I can't say 100% that the addition or removal of other pals has made that much of a difference, as before this was installed, we decided outright to use it as you see it. Between myself and the site admins and moderators, we found the star rating system did not go over well with the users, and have removed it for user ratings, and will probably modify the way it is used in thread ratings - so this meant all the 'rating' pals were not required although I do still have them XHTML'd.
Something you might notice too is the addition of the welcome message. This is another 'pal', being extracted from a board which no one other than Admins have permission to see when 'in' the threads package. This adds a query but allows me to keep the ever changing welcome message as posts (top 1 returned). I could just keep editing 1 post, but this way I can look back on the history of the site whenever I choose.
I'm still in debate about the template idea as being advantageous or not as many of the Threads templates seem as entangled with code as the code is entangled with HTML!
Plus I have on-line editing thru the Bravidio Control Panel. I have also noticed that modifying a template thru Threads Admin can generate XHTML errors unless you're careful with some of those special characters: When the template comes up in the Threads editor it is not 100% the truth!
Ah, so much fun!
Thanks again Dave.
Gord