April 27, 2009 at 9:58 am
Hi
Did you run your single script against each of the databases? Just to verify that it always runs about 1 second on each of them. It could be possible that the script takes only 1 second on one database but 20 seconds on another.
Greets
Flo
April 27, 2009 at 10:02 am
There are different amounts of data in each database, but for my testing I executed both scripts against the same database for comparison.
April 27, 2009 at 10:16 am
Code (4/27/2009)
There are different amounts of data in each database, but for my testing I executed both scripts against the same database for comparison.
You executed both scripts against same database? I thought the request was that the script should automatically execute on all databases?
So if the dynamic script takes 2 minutes you have to compare it with the execution time of your script on each database. 😉
Greets
Flo
April 27, 2009 at 10:28 am
Take a look at the dynamic script I posted above last week. For testing purposes I modified it so it executes against ONE database, not all of them. I can manually run the non-dynamic script against all 20 DB's individually, and the total combined run time is 00:02:31 When I run the dynamic script against the same 20 DB's it takes 03:56:47 to finish running.
Viewing 4 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply