What are the challenges you face when working across database platforms? Take the survey

SQLPrompt very slow.

gvarol@corelogic.comgvarol@corelogic.com Posts: 90 Bronze 3
edited December 9, 2011 11:15AM in SQL Prompt Previous Versions
[Post text removed on request of the user]


  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    MikeyCMikeyC Posts: 249 Bronze 3
    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?
  • Options
    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.

    Paul Stephenson
    Project Manager, Red Gate
  • Options
    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.


Sign In or Register to comment.