SQLPrompt 5.1.4.11 very slow.

• 
  Many thanks for your post and apologies for inconvenience caused.
  
  Have you tried the suggestion I emailed to you?
  
  Let me know if the issue still persists.

  Anu D May 19, 2011 11:08

  - 0 +
• 
  I too have noticed that SQL Prompt 5.1 is very slow with larger batches, is there something that we can try other than shortening how much code it looks at?

  MikeyC May 19, 2011 12:09

  - 0 +
• 
  That sort of slowdown seems extreme. Would one of you share your SQL batch with us? It's possible there's a particular construct SQL Prompt doesn't cope with very well, like we found with CTEs in version 5.0.
  
  Please send it to support@red-gate.com if you're willing.
  
  Thanks,
  Paul

  Paul Stephenson May 20, 2011 04:27

  - 0 +
• 
  The subject line says it all. I think I've got the latest version, and for instance I can type ahead a short select statement, and 30-seconds later or longer it appears. It didn't used to be that way, even on the exact same database. Maybe since our upgrade to R2? We have no non-R2 servers left to test this on.
  
  TIA,
  
  -George

  Gjr0Gjr0 December 09, 2011 11:15

  - 0 +

Add comment

Please sign in to leave a comment.