Red Gate forums :: View topic - SQL Prompt - lag in typed code appearing
Return to www.red-gate.com RSS Feed Available

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

SQL Prompt - lag in typed code appearing

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
USFRMerrill



Joined: 02 May 2013
Posts: 2

PostPosted: Thu May 02, 2013 3:08 pm    Post subject: SQL Prompt - lag in typed code appearing Reply with quote

As I type in the Query Window I am able to type 30 + character before the characters appear on the screen.
Version: 5.3.6.28 Professional Edition
Items tested
1. When the query is saved (does not matter if local to PC or network) the slowness appears
2. If "Disable Code Suggestion" is set then there is NOT a performance issue.
3. Red Gate log file reports the below error.
4. Checked for update. No new updates.
5. Query is only 134 lines

Error log
02 May 2013 13:37:24,329 [11] ERROR RedGate.SqlPrompt.Metadata.Options.OptionsBase - Couldn't read options on attempt 0
System.IO.IOException: The process cannot access the file 'C:\Users\rmerrill\AppData\Local\Red Gate\SQL Prompt 5\RedGate_SqlPrompt_Engine_EngineOptions.xml' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize)
at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks)
at RedGate.SqlPrompt.Metadata.Options.OptionsBase.(Type )
Back to top
View user's profile Send private message
USFRMerrill



Joined: 02 May 2013
Posts: 2

PostPosted: Thu May 02, 2013 3:14 pm    Post subject: Reply with quote

Scratch the original posted error message. That was due to attempting to increase this setting <ParserLookBackDistance>5000</ParserLookBackDistance>

This did not make a difference.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 683
Location: Cambridge

PostPosted: Fri May 03, 2013 4:43 pm    Post subject: Reply with quote

Many thanks for your post and apologies for inconvenience caused.

If you wish to alter the behaviour of SQL Prompt where it does not suggest variables over large blocks of SQL or fails to provide help with large scripts, you can edit the RedGate_SQLPrompt_Engine_EngineOptions.xml file.

This file should be in the below location:

%USERPROFILE%\AppData\Local\Red Gate\SQL Prompt 5

The string in the file you need to edit is <ParserLookBackDistance>5000</ParserLookBackDistance><ParserLookAheadDistance>3000</ParserLookAheadDistance>

The figure detailed here is in bytes. You can decrease the look back distance as much as you like. However please be aware that increasing the value; depending on your hardware, there may be a considerable degradation in the performance of the tool.

Please let me know how you get on.
_________________
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
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