Tab History Slow

• 
  Hi, Thank you for your forum post.
  
  What version of SQL Prompt are you using?
  
  I am not aware of the Tab History feature of SQL Prompt to be a performance problem.  However, it has been known that the Code Analysis feature of SQL Prompt to cause performance issues.
  
  If you expand the SQL Prompt menu item in the Toolbar -> By default the Enable Code Analysis option is enabled. If you disable the Enable Code Analysis option, does this improve the performance of the Tab History feature?
  
  Many Thanks
  Eddie

  Eddie D July 15, 2019 10:15

  - 0 +
• 
  Thanks Eddie.  You're right.  That did speed it up.  I guess I'll put up with the slowness because I like the Code analysis too much.
  
  And I'm on version 9.5.10.10741.

  JonBrune July 15, 2019 17:42

  - 0 +
• 
  Hi, Thank you for your reply.
  
  If the performance degrades to a point where this becomes a blocker for you, please submit a support ticket via the support portal https://productsupport.red-gate.com/hc/en-us and click the 'submit a request' blue button.
  
  I guess you can enable the Code Analysis feature when required and disable when you do not need to use it.
  
  Many Thanks
  Eddie

  Eddie D July 18, 2019 08:41

  - 0 +
• 
  I'm using 10.0.1.12389 and I clocked this at ~6 seconds to open regardless of whether Code Analysis is enabled or not.  It has been that way for several versions
  

  TimB November 19, 2019 19:58

  - 0 +
• 
  Agreed with TimB - the 10.0.1.12389 has slowed it down showing things significantly.

  jsreynolds1 November 20, 2019 00:14

  - 0 +

Add comment

Please sign in to leave a comment.