How can we help you today? How can we help you today?

Union All Evil

I wrote a recursive CTE and attempted to use UNION ALL
unfortunately this caused SQL Prompt to go slower than molasses in February :(

I ended up disabling Sql Prompt until I finished the query.
Is this a know bug and if so is there a work around?

[/b]
tdartt
0

Comments

2 comments

Sort by
  • Paul Stephenson
    Yes, we did discover after the release of SQL Prompt 5.0 that CTEs do make SQL Prompt perform very slowly. The developers have now produced a fix, which will be included in SQL Prompt 5.1.

    I understand that doing CTE-intensive work is very difficult with the current version, so we've also backported the fix to SQL Prompt 5.0. It hasn’t been fully regression-tested, so we’re only telling people who have told us they’ve experienced this specific issue.

    Please email me at paul.stephenson@red-gate.com if you're having problems with slow CTEs and I'll send you the link.

    Regards,
    Paul
    Paul Stephenson
    0
  • MikeyC
    I too have noticed this, and have sent an email requesting the fixed version.
    MikeyC
    0

Add comment

Please sign in to leave a comment.