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

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?



  • Options
    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.

    Paul Stephenson
    Project Manager, Red Gate
  • Options
    MikeyCMikeyC Posts: 249 Bronze 3
    I too have noticed this, and have sent an email requesting the fixed version.
Sign In or Register to comment.