SQL Prompt is triggering "Refresh Suggestions" constantly

KatMakes

I've been using SQL prompt for months without issue, then suddenly this morning nearly anytime I try to type a SQL statement the Refresh Suggestions popup (where it shows a progress bar as it indexes objects) shows up and interrupts any suggestions that were being offered.

How do I change this so it only refreshes suggestions when I invoke the keyboard shortcut? Before today it would only auto refresh suggestions when I connected to a new database. Now the auto refresh is so often it makes suggestions unusable.

Kurt_M

Hi @KatMakes

With regards to the constant refreshing, is it possible you have the following feature enabled? 

This is under the SQL Prompt Options > Experimental Features:



If yes, can you try disabling this to see if this fixes your issue?

KatMakes

Hi Kurt,

That did indeed solve the issue. I had forgotten that feature was experimental.

Once the feature is finished I'm sure it'll be great. But for some reason on this one Server/DB it just wants to constantly refresh itself.

Thanks again!
KatMakes