DavidB: I ran the script with the execution times and got the following:

SQL Server parse and compile time:

CPU time = 11672 ms, elapsed time = 11965...

thanks for the replies everyone I'll give these a try and let you know what I find