There are times when a connection gets broken or I added a new object. When I reset and refresh the cache, I don't get the suggestions I am expecting.
For example I type: Use and I am expecting a list of databases and I don't get them. I keep hitting ctrl-space and no databases are showing. I am on a VPN connection and sometimes it's pretty slow. I need a way to know that SQL Complete has finished refreshing its cache and it's just taking some time to finish. Sometimes the query window gets 'bad' and I need to open a new window. I want to know if this is the case so I don't have to wait thinking SQL Complete is still refreshing its cache.
Need visual indicator that refreshing the cache is complete
Re: Need visual indicator that refreshing the cache is complete
We will review this post and will answer you as soon as possible.
Re: Need visual indicator that refreshing the cache is complete
We recommend you to try selecting 'Edit -> Code Completion -> Reset Suggestions Cache' from the main menu.
Re: Need visual indicator that refreshing the cache is complete
I know about this. I want a visual indicator that it's done refreshing.
When would one reset vs refresh?
When would one reset vs refresh?
Re: Need visual indicator that refreshing the cache is complete
You can add a suggestion on the UserVoice forum where other users can vote for it https://devart.uservoice.com/forums/87893-sql-completeI know about this. I want a visual indicator that it's done refreshing.
We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.
The 'Refresh Local Cache' fully resets the cache for all of the databases of the connection and starts object describing for each database the user refers to from scratch, whereas the 'Reset Suggestions Cache' updates the suggestion list with the objects for the current database only.When would one reset vs refresh?