Version 8 slower than Version 7

• 
  The new version seems to be significantly slower than 7.x Is it just me or is anyone else experiencing the same issue?

  dewet May 15, 2017 13:43

  - 0 +
• 
  I had to return back to 7.5. Version 8 is just crazy slow...

  dewet May 16, 2017 12:47

  - 0 +
• 
  Hi dewet,
  
  Would it be possible to tell us a little more about what features were slower and when you experienced the slowdown?
  
  Best wishes,
  
  Michael Clark
  Technical Lead, SQL Prompt

  Michael Clark May 19, 2017 14:03

  - 0 +
• 
  Me too. Details below but this is painful since the update to v8.
  
  Love the product but it's made it almost unusable.
  
  
  
  SQL Prompt version 8.0.0.1241
  Microsoft SQL Server Management Studio: 13.0.16106.4
  

  TomC May 24, 2017 07:27

  - 0 +
• 
  Edit: just to clarify. The loading of suggestions is what's slow. But the biggest problem is that this causes the actual typing speed to lag making it extremely frustrating to use.
  
  
  

  TomC May 24, 2017 07:29

  - 0 +
• 
  Hi Michael,
  just as TomC said - suggestion is slow and even writing inside query is slow (I write letters and it lags few ms until they appear) => absolutely unusable (same in SSMS 2017 and 2016).
  Even snippets are no recognized, when you write text too fast (like ssf or so).
  Please, do sth about it.

  dewet May 24, 2017 08:18

  - 0 +
• 
  Hi dewet,
  
  I have logged a support ticket for you and will email you shortly!

  Anu D May 31, 2017 15:07

  - 0 +
• 
  I believe it was actually one of the version 8 point releases where I noticed the sluggishness, not the initial version 8 release.
  
  Your download old versions of products page is missing v7.5 btw, which I will be rolling back to (since I have the installer in my download folder, luckily).

  JColton May 31, 2017 20:35

  - 0 +
• 
  I can confirm uninstalling v8 and reinstalling 7.5.1.1000 resolves the issue. I'm using SSMS 2012. (Microsoft SQL Server Management Studio 11.0.5058.0).

  JColton May 31, 2017 21:04

  - 0 +
• 
  Same here. The suggestion lists in v8 are crazy slow and it makes the product unusable. I just removed v8 and rolled back to 7.1 (why can't I download 7.5?).
  
  I take that back. I'm using SSMS 2016, and Prompt 7.1 does not work. Since I can't download a previous version later than 7.1 (7.2 was the first version that supported SSMS 2016), I now have to reinstall Prompt v8 and deal with the crazy slow performance. UGH!!
  
  Please RedGate fix this soon!

  CMeese June 03, 2017 14:40

  - 0 +
• 
  Hi CMeese,
  
  Sorry to hear you are also experiencing a slowdown. You can download 7.5.1.1000 directly here:
  http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_7.5.1.1000.exe
  
  Best,
  Michael

  Michael Clark June 05, 2017 12:03

  - 0 +
• 
  I'd like to second this. 8.0.1.1383 has seriously slowed down pretty much all intellisense/suggestions. I have only tested within ssms2016 (13.0.16106.4), but the user community here is pretty unanimous.

  mhickin June 07, 2017 07:07

  - 0 +
• 
  Hi mhickin,
  
  Thanks for the feedback, we want to understand what could be causing the slowdown.
  
  Would it be possible to be specific at the precise moments where the slowness occurs?
  e.g. is it when you accept the suggestion or when the suggestions list loads?
  
  Best,
  Michael

  Michael Clark June 07, 2017 16:05

  - 0 +
• 
  Hi @dewet, @TomC, @JColton, @CMeese, @mhickin ,
  
  We've just released a new build of SQL Prompt (8.0.3.1587) that contains some performance improvements for suggestions. I hope you can try it out and let us know how it is performing now, or if there's any more we can do.
  
  Thanks,
  James

  James R June 14, 2017 12:41

  - 0 +
• 
  I have only done a quick test, but the issue seems to be resolved.
  
  Thanks!

  JColton June 15, 2017 14:20

  - 0 +

Add comment

Please sign in to leave a comment.