Adriaan Davel (5/9/2008)
Hi Wayne,Nice one, have you looked at the performance of using the XML joins in your stored procedure?
In my "casual" testing, XML datasets up to about 1000 "records" performed pretty fast. Beyond 1000 it started slowing down; when it got to 5000 it was crawling, and I stopped one query with > 20,000 elements after about an hour. Most of the XML datasets I use are in dealing with SSRS, where the users want to be able to select > 1 option. Most of these selections are kept down to 15000. but, they've been told...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes