測試代碼:declare @i int
set @i = 3
print getdate()
while( @i < 10000000)
begin
INSERT [EB_REPAIR] ( [RE_ID] , [RE_CODE_VALUE] , [RE_CD_SATISFITION_NO] , [RE_LIST_NO] , [RE_IN_LIST_DATE] , [RE_REPAIR_SITE] , [RE_CUS_NAME] , [RE_DO_DATE] , [RE_MACHINE_TYPE] , [RE_MACHINE_COUNT] , [RE_PRODUCT_PLACE] , [RE_MACHINE_NO] , [RE_KEEP_REPAIR_NO] , [RE_INVOICE_NO] , [RE_DAYS] , [RE_INCOICR_DATE] , [RE_BUY_PLACE] , [RE_REPAIR_DATE] , [RE_FAULT] , [RE_FAULT_REASON] , [RE_FINISH_DATE] , [RE_FINISH_DAYS] , [RE_REPAIRER] , [RE_ADD_MENUS_FEE_COUNT] , [RE_FEE] , [RE_ALL_FEE] , [RE_ALL_PART] , [RE_FEE_RATE] , [RE_TOTAL_FEE] , [RE_CHANGE_FEE] , [RE_IS_REREPAIR] , [RE_OLD_LIST_NO] , [RE_OLD_FINISH_DATE] , [RE_IS_IMPORTANT_CUS] , [RE_REMARK] , [RE_IS_REPLACE] , [RE_IS_REPEAT] , [RE_IS_UNKOWN] , [OWNER_ID] , [IS_DELETE] , [CREATE_USER_ID] , [CREATE_DATE] , [UPDATE_USER_ID] , [UPDATE_DATE] ) VALUES ( @i , '1 ' , '1 ' , '1' , '2003-12-14 00:00:00.000' , 1 , '4444' , '2003-12-13 00:00:00.000' , '123123123' , 123123 , '123' , '123' , '1222222222222222' , '222' , 2222 , '2003-12-12 00:00:00.000' , '2' , '2003-12-12 00:00:00.000' , '2003-12-12' , '2003-12-12' , '2003-12-12 00:00:00.000' , 1212 , '2003-12-12' , 1212 , 1212.0 , 1212.000 , 1212.000 , '1212' , 1212.000 , 1212.000 , 1212 , '1212' , '2003-12-13 00:00:00.000' , 12 , '2003-12-132003-12-132003-12-13' , 1 , 1 , 111 , '111' , 0 , '1111' , '2003-12-13 00:00:00.000' , '1' , '2003-12-13 00:00:00.000' )
set @i = @i + 1
end
print getdate()
結果,1 分鐘能插10000條左右記錄,Sql Server進程cpu佔用3%-60% 記憶體佔用,從20M慢慢增加
我的機子效能不是很好,
C1.7
256M
各位也可以試試,比較有意思!
