Union All Evil

tdartttdartt Posts: 2
edited February 17, 2011 1:11PM in SQL Prompt Previous Versions
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]

Comments

  • 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 [email protected] if you're having problems with slow CTEs and I'll send you the link.

    Regards,
    Paul
    Paul Stephenson
    Project Manager, Red Gate
  • I too have noticed this, and have sent an email requesting the fixed version.
Sign In or Register to comment.