We just wanted to give our Publish users a heads up. If you're utilizing Tagging functionality within Publish you may have noticed some performance issues with the module. We're developing a fix for the functionality in the 5.2 release, but for now you can make a simple change to the [publish_spGetItemsForTags] stored procedure.
Basically the module is pulling back every article for a particular tag, or list of tags, for sites with a large number of articles and tags this can cause quite a load on the SQL server as well as thru the use of caching cause a large amount of memory consumption. A temporary fix for this, though limiting functionality, is to modify the spGetItemsForTags to only pull back X number of items. In the stored proc I've simply added a "top 25" to limit the number of items pulled back when called. This isn't the solution that will be included in the 5.2 release, but should help as an interim fix for anyone having this problem.
The downfall to this approach is that it limits the number of items pulled back in your lists, possibly affecting your users in their ability to find older articles that were tagged. This will be resolved with paging in the 5.2 release.
Any feedback is always appreciated
select top 25 [name] as 'ChildName', Thumbnail, itemId as 'ChildItemId', ItemVersionId