Red Gate forums :: View topic - Slow response times while typing
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

Slow response times while typing

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Shai-Hulud



Joined: 27 Jan 2010
Posts: 5

PostPosted: Wed Jan 27, 2010 7:57 am    Post subject: Slow response times while typing Reply with quote

Hi,

I have just gotten my new Workstation and installed the Dev Tools from scratch, including SQL Server 2008 Client Tools, SP1 and SQL Prompt 4.0.3.

This is a rather high spec machine but whenever I start typing queries, once the suggestion list pops up / moves while I'm typing, it takes ages. It eats keystrokes and typing queries is a pain / very slow. I have increased the suggestion pop-up time to 500ms (and I usually do not pause that long while typing Smile), but still the pop up "tries" to pop up and then starts moving while I'm typing. Which would be ok if it wasn't slowing down my typing experience that much

Any hints / solutions would be highly appreciated

Thanks in advance

Kai Iske
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Thu Jan 28, 2010 10:36 am    Post subject: Reply with quote

Thanks for your post and apologies for the inconvenience caused.

Can you kindly follow the steps mentioned in our knowledgebase here

Kindly let me know if this fixes the issue.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
mobsite



Joined: 22 Dec 2009
Posts: 1

PostPosted: Thu Feb 18, 2010 7:54 pm    Post subject: slow typing response time Reply with quote

I am seeing the same symptoms on a very similar application setup. Don't think it's hardware specific, because I was seeing the same problem on my old workstation that was recently replaced with a docked laptop.

The problem appears for me when the length of the script increases. However, it starts when the overall length is actually quite small (for example, 120 lines).

I have noticed that restarting SSMS seems to result in an improvement, but it does eventually degrade again over time.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Fri Feb 19, 2010 9:25 am    Post subject: Reply with quote

Hello mobsite,

Thanks for your post.

Can you email support@red-gate.com and I will provide you the workaround for this issue?

Kindly add the forum link in your email.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Shai-Hulud



Joined: 27 Jan 2010
Posts: 5

PostPosted: Fri Feb 19, 2010 9:27 am    Post subject: Reply with quote

BTW: The Knowledge Base article fixed the issue, but I had to almost completely disable HW acceleration which I find quite strange as no other app seems to be having issues drawing WinForms apps and moving them around.

Will there be any update to the IntelliSense popup rendering anytime soon?
Back to top
View user's profile Send private message
nhustak



Joined: 09 May 2006
Posts: 34

PostPosted: Tue Mar 02, 2010 4:50 am    Post subject: Reply with quote

OK guys I got a serious issue with disabling hardware acceleration on my Nvidia graphic cards to get SQL Prompt to work.

That's not an acceptable solution.

I'm running the latest drivers with 7000 & 8000 series cards. The pauses and delays are immediate. I'm talking clicking into the window and nothing happens for a few seconds.

And the delays are intermitent. I've noticed that it will work just fine and then suddenly in the middle of populating the drop down it will pause. I just opened up a database immediately after a reboot and the delay was present.

I find it highly unlike the issue is with my Nvida cards, especially when people are reporting the issue on laptops.

This is a serious problem and is approaching the 'uninstall sql prompt' and go back to SQL prompt 3 level...again.

Is there a reason why we have to email to get the workaround and is this different from the disable HW acceleration?

Best Regards,
Nick Hustak
Back to top
View user's profile Send private message
Shai-Hulud



Joined: 27 Jan 2010
Posts: 5

PostPosted: Tue Mar 02, 2010 7:17 am    Post subject: Reply with quote

I double that! This is (a) more than annoying and (b) I do not understand the reason.

Please advise
Back to top
View user's profile Send private message
bholt



Joined: 01 Sep 2010
Posts: 1

PostPosted: Wed Sep 01, 2010 10:45 pm    Post subject: Re: Reply with quote

Shai-Hulud wrote:
I double that! This is (a) more than annoying and (b) I do not understand the reason.

Please advise


So where are we on this issue. One of our users is also having the problem.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group