Our project list is taking too long to load and we have track it down to large overheads associated with Toolbox expanding every category in our list. If this expansion was not occurring I feel the process of opening the project list would be about 5-10 second faster everytime.

Is there anyway to turn off the auto-expand for the categories in the project list view?

If someone knows a bit about this one would be great to discuss.

Below is a typical update query that Toolbox is running on every category that meets MV's criteria and each time this is executed (approx 2000) it takes between 3 and 15ms which starts to really add up.

exec sp_executesql N'UPDATE Categories SET [IsExpanded] = @IsExpanded WHERE ID = ''2c209f22-dad1-479e-abf0-f5b47a621dac''

IF @@ROWCOUNT=0

INSERT INTO Categories([IsExpanded]) VALUES(@IsExpanded)',N'@IsExpanded bit',@IsExpanded=1