We're testing out a new release of an upgraded installation (from CMS 6 R2) we're there are data stored on DynamicDataStore. We are experincing big performance problems on the startpage. I have tracked down that DynamicDataStore.SetContextObjects is taking about 7(!) seconds to complete.
Any ideas of why and how to speed up the performance?
When looking in the code I see that the only thing SetContextObjects i doing is copying values from on dicitonary to another. That should not take that long (no locks either).
What is it that gets loaded from DDS (you could probably see it from e.g. SQL Profiler)?
I think I got it down to an acceptable level now (a couple of ms). It was retrieving a vast amount of data (4000 simple objects) all because the "Take" expression in the Linq-expression was ran after the question had been asked to SQL Server. That in combination with a busy SQL Server seems to have been the cause.