How can we help you today? How can we help you today?

Having to wait on SQLPromt when pasting code into QA.

I have pasted queries into a QA window and have had to wait until SQLPrompt finishes its snapshot of the master db. I have seen this slowdown on both small and large databases. Furthermore, closing a search/replace window takes time after hitting cancel. These slowdowns with QA detract greatly from the advantages of using SQLPrompt.
bconlon
0

Comments

2 comments

Sort by
  • Tilman
    Hi,
    I have pasted queries into a QA window and have had to wait until SQLPrompt finishes its snapshot of the master db. I have seen this slowdown on both small and large databases.
    We scan the master database for system stored procedures and such. However, after the first time it should load this information from a file, which should be much faster.
    Furthermore, closing a search/replace window takes time after hitting cancel. These slowdowns with QA detract greatly from the advantages of using SQLPrompt.
    I was not able to reproduce your problem. Are you using the latest patch (available here http://www.red-gate.com/messageboard/vi ... php?t=4031)?

    Regards,

    Tilman
    Tilman
    0
  • bconlon
    I am running the latest version.
    bconlon
    0

Add comment

Please sign in to leave a comment.