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

Slowness opening files in 3.8

I have noticed since I upgrade from SQL Prompt 3.7 to 3.8 that opening a .SQL file in SMSS takes considerably longer. I don't remember any delay with 3.7, but now with 3.8 it usually takes 5 or more seconds. (Small 38 line files take around 2 seconds to open.)

If I disable SQL Prompt the file opens immediately. But as soon as I pick the menu to enable SQL Prompt it then takes the 5+ seconds before I can do anything in SMSS.

Is this normal?
MikeyC
0

Comments

3 comments

Sort by
  • chris.buckingham
    I suggest that you go into SSMS file menu, SQL Prompt, through the Prompt cache management, and click Refresh All before importing SQL scripts into SSMS.
    chris.buckingham
    0
  • MikeyC
    Refreshing all before opening a SQL script didn't make any difference. It still takes around 6 seconds to load a script, even if I close the script and open the same one again. (It is 1500+ lines long.)

    Michael
    MikeyC
    0
  • chris.buckingham
    I have submitted this as a problem SP-1222 into our bug database, and will keep you posted.
    chris.buckingham
    0

Add comment

Please sign in to leave a comment.