Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @timer1 datetime; set @timer1 = getdate();declare @timer2 datetime; set @timer2 = getdate();
- declare @debug bit = 1;
- declare @max_x integer;set @max_x = 1000;
- declare @x integer;set @x = 0;
- declare @StatusIdent varchar(30);
- while @x < @max_x begin
- -- execute proc
- -- cleanup
- set @x = @x + 1;
- end;
- /*------------------------------------------------------------------------------------------------*/
- if @debug = 1 begin set @timer2 = getdate();print 'total time: ' + cast(convert(decimal(20, 4), datediff(ms, @timer1, @timer2) / 1000.00) as varchar(10)) + ' seconds';end;
- /*------------------------------------------------------------------------------------------------*/
- print 'executions: ' + cast(@max_x as varchar(10));
- declare @avg decimal(20, 4);set @avg = datediff(ms, @timer1, @timer2) / cast(@max_x as decimal(20, 4));
- print 'average: ' + cast(convert(decimal(20, 4), @avg / 1000.00) as varchar(10)) + ' seconds'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement