Cache Management slows down Management Studio startup

edockx

Hi

I've been using SQL Prompt for a few months now and have noticed that it can slow down the Management Studio's startup.

When there are several schema's from different servers and databases in the Cache Management, the startup time will increase.

When the cache is cleared, my Management Studio starts in 3 seconds. With around 10 to 15 schema's in the Cache Management, it starts in about 19 seconds.

The servers are located on different servers on different locations. The are not accessible at the same time.

Greetings

Erwin Dockx

Daniel Handley

Hi Erwin

We are working on version 3.5 at the moment which has some changes to the cache management.
In the new version you can disable the auto update to the cache and then manually refresh from a command on the menu - there may be shortcut keys as well but don't hold your breath as we are running out of available ones.

Regards
Dan

Bart Read

Hello Erwin,


You should find that this has been significantly improved in the version 3.5 release candidate which is now available for download:

http://www.red-gate.com/messageboard/vi ... php?t=5263


Thanks,
Bart