Thanks to Jill Carter from the Management Report Team for a prompt reply to my questions posed to them yesterday. Refer to my last post.
It seems that the team tried to "group" the entities together and fire of fewer queries but found that is was slower. Who would have thought?
There are apparently some improvements on SQL2008 which we can look forward to. I have also suggested that they multi-thread the queries but at this point it cannot be done as a hotfix as it my destabilize the product. Watch this space.
- Paul Steynberg