100% cpu when autocomplete turned on -- SQL Pro MSSQL
When I first purchased this app it worked perfectly. However, one update (about a month ago?) essentially rendered the 'auto-complete' feature useless. Typing anything that triggers autocompletion text kicks CPU usage to on sqlpro to 100% and brings up a beachball.
I am using this on a db with a massive number of tables. However, when I first purchased it did work with minimal lag. During this high cpu utilization there is no network activity.
Hi. First sorry about that. A few questions to help figure this out.
1. Are you using any CTEs? (Statements including WITH).
2. if you have a blank query and hit escape, does the issue occur?
3. If possible, have you noticed what the last sql keyword (select, from, join, where, order by, etc) is when this occurs?
thanks and again sorry for the issue.