Version 8 slower than Version 7

System

This discussion was created from comments split from: Latest stable build of SQL Prompt is 8.0.0.1241 (11th May).

dewet

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

dewet

I had to return back to 7.5. Version 8 is just crazy slow...

Michael Clark

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

TomC

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

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.

dewet

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.

Anu D

Hi dewet,

I have logged a support ticket for you and will email you shortly!

JColton

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

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).

CMeese

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!

Michael Clark

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

mhickin

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.

Michael Clark

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

James R

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

JColton

I have only done a quick test, but the issue seems to be resolved.

Thanks!