Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. declare @timer1 datetime; set @timer1 = getdate();declare @timer2 datetime; set @timer2 = getdate();
  2. declare @debug bit = 1;
  3. declare @max_x integer;set @max_x = 1000;
  4.  
  5.  
  6. declare @x integer;set @x = 0;
  7. declare @StatusIdent varchar(30);
  8.  
  9. while @x < @max_x begin
  10.  
  11. -- execute proc
  12.  
  13.  
  14. -- cleanup
  15.  
  16.  
  17. set @x = @x + 1;
  18.  
  19. end;
  20.  
  21. /*------------------------------------------------------------------------------------------------*/
  22. 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;
  23. /*------------------------------------------------------------------------------------------------*/
  24.  
  25. print 'executions: ' + cast(@max_x as varchar(10));
  26.  
  27. declare @avg decimal(20, 4);set @avg = datediff(ms, @timer1, @timer2) / cast(@max_x as decimal(20, 4));
  28.  
  29. print 'average: ' + cast(convert(decimal(20, 4), @avg / 1000.00) as varchar(10)) + ' seconds'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement