存储过程执行耗时波动请教!!急
TLFLY 2003-10-20 07:56:49 以下为程序运行过程中对同一存储过程调用耗时的记录,请问为何会出现如此大的波动情况?(从最小的40ms到最到的35000ms),存储过程主要执行插入操作
日期时间 存储过程 执行耗时(ms)
2003-10-15 13:56 dhsb_step 30
2003-10-15 13:57 dhsb_step 30
2003-10-15 13:57 dhsb_step 481
2003-10-15 14:00 dhsb_step 70
2003-10-15 14:00 dhsb_step 30
2003-10-15 14:00 dhsb_step 141
2003-10-15 14:01 dhsb_step 3926
2003-10-15 14:05 dhsb_step 4106
2003-10-15 14:05 dhsb_step 6690
2003-10-15 14:05 dhsb_step 6930
2003-10-15 14:06 dhsb_step 7091
2003-10-15 14:06 dhsb_step 60
2003-10-15 14:07 dhsb_step 121
2003-10-15 14:12 dhsb_step 40
2003-10-15 14:12 dhsb_step 40
2003-10-15 14:13 dhsb_step 100
2003-10-15 14:13 dhsb_step 250
2003-10-15 14:13 dhsb_step 40
2003-10-15 14:14 dhsb_step 30
2003-10-15 14:14 dhsb_step 150
2003-10-15 14:14 dhsb_step 40
2003-10-15 14:14 dhsb_step 40
2003-10-15 14:14 dhsb_step 110
2003-10-15 14:15 dhsb_step 15432
2003-10-15 14:15 dhsb_step 50
2003-10-15 14:16 dhsb_step 130
2003-10-15 14:16 dhsb_step 30
2003-10-15 14:16 dhsb_step 100
2003-10-15 14:17 dhsb_step 5078
2003-10-15 14:17 dhsb_step 60
2003-10-15 14:17 dhsb_step 100
2003-10-15 14:21 dhsb_step 40
2003-10-15 14:21 dhsb_step 160
2003-10-15 14:22 dhsb_step 30
2003-10-15 14:22 dhsb_step 12428
2003-10-15 14:22 dhsb_step 30
2003-10-15 14:22 dhsb_step 130
2003-10-15 14:23 dhsb_step 30
2003-10-15 14:23 dhsb_step 130
2003-10-15 14:23 dhsb_step 30
2003-10-15 14:23 dhsb_step 131
2003-10-15 14:23 dhsb_step 30
2003-10-15 14:24 dhsb_step 181
2003-10-15 14:24 dhsb_step 40
2003-10-15 14:24 dhsb_step 90
2003-10-15 14:24 dhsb_step 3966
2003-10-15 14:25 dhsb_step 40
2003-10-15 14:27 dhsb_step 30
2003-10-15 14:27 dhsb_step 30
2003-10-15 14:28 dhsb_step 40
2003-10-15 15:38 dhsb_step 40
2003-10-15 15:39 dhsb_step 40
2003-10-15 15:42 dhsb_step 30
2003-10-15 15:42 dhsb_step 300
2003-10-15 15:44 dhsb_step 30
2003-10-15 15:44 dhsb_step 141
2003-10-15 15:46 dhsb_step 30
2003-10-15 15:46 dhsb_step 30
2003-10-15 15:54 dhsb_step 40
2003-10-15 15:55 dhsb_step 30
2003-10-15 16:06 dhsb_step 30
2003-10-15 16:15 dhsb_step 4606
2003-10-15 16:25 dhsb_step 3755
2003-10-15 16:25 dhsb_step 221
2003-10-15 16:54 dhsb_step 631
2003-10-15 16:54 dhsb_step 30
2003-10-15 16:55 dhsb_step 40
2003-10-15 17:00 dhsb_step 41
2003-10-15 17:00 dhsb_step 851
2003-10-16 8:39 dhsb_step 3004
2003-10-16 8:39 dhsb_step 661
2003-10-16 9:28 dhsb_step 240
2003-10-16 9:29 dhsb_step 391
2003-10-16 9:29 dhsb_step 160
2003-10-16 9:29 dhsb_step 140
2003-10-16 9:30 dhsb_step 15873
2003-10-16 9:38 dhsb_step 31
2003-10-16 14:53 dhsb_step 9894
2003-10-16 14:53 dhsb_step 13509
2003-10-16 14:53 dhsb_step 11497
2003-10-16 14:54 dhsb_step 13329
2003-10-16 14:54 dhsb_step 7912
2003-10-16 14:56 dhsb_step 11467
2003-10-16 14:57 dhsb_step 9273
2003-10-16 15:15 dhsb_step 40
2003-10-16 17:17 dhsb_step 7441
2003-10-16 17:18 dhsb_step 6029
2003-10-16 17:18 dhsb_step 4917
2003-10-16 17:18 dhsb_step 7120
2003-10-17 8:36 dhsb_step 842
2003-10-17 8:36 dhsb_step 1071
2003-10-17 8:43 dhsb_step 34589
2003-10-17 8:43 dhsb_step 10445
2003-10-17 8:44 dhsb_step 11747
2003-10-17 8:44 dhsb_step 13780
2003-10-17 8:45 dhsb_step 21952
2003-10-17 8:46 dhsb_step 190
2003-10-17 8:46 dhsb_step 1382
2003-10-17 8:46 dhsb_step 40
2003-10-17 8:46 dhsb_step 631
2003-10-17 8:55 dhsb_step 90
2003-10-17 8:55 dhsb_step 591
2003-10-17 8:56 dhsb_step 40
2003-10-17 8:56 dhsb_step 230
2003-10-17 8:56 dhsb_step 891