Collections taking a long time to refresh

For quite a while now we have had issues where if we manually update a collection, it takes a very long time for it to refresh.

We spent a considerable amount of time troubleshooting this, seeing if it was a setting or our configuration, bringing down the regularity they auto update and even whether the hardware wasn’t a high enough spec. In the end we settled on the issue simply being due to the number of collections and the frequency at which they update. In the colleval.log we could see it was constantly refreshing collections and thought that maybe the collections we manually update/refresh were just queued up.

We were about to go through the lengthy and tiresome task of removing collections that were no longer used (making sure the collections weren’t being used for adverts or as limiters) as well as looking into any SQL heavy queries which were maybe to blame when Microsoft released the below update in the nick of time!

http://support.microsoft.com/default.aspx?scid=kb;en-us;982400&sd=rss&spid=12769

The issue turned out to be exactly what we thought it was and since we have installed the hotfix, our collections are updating in under 10 seconds.

Advertisements

One Response to Collections taking a long time to refresh

  1. Genie says:

    Thank you for your find of solution it work on me thx šŸ˜€

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: