Union All Evil

tdartt

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]

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

MikeyC

I too have noticed this, and have sent an email requesting the fixed version.