SANAL TABLOYA VERİ EKLEME TEST: Yaklaşık 600.000 kayıt

1.Metod = ortalama 180ms

CREATE TABLE #tosun( geEvrakID int, doclangId tinyint, bilgiEdinme tinyint);

INSERT INTO #tosun

SELECT geEvrakID, doclangId, bilgiEdinme FROM dbo.GelenEvrak;

drop table #tosun;

2.Metod = ortalama 250ms

SELECT geEvrakID, doclangId, bilgiEdinme INTO tosun FROM dbo.GelenEvrak;

drop table tosun;

3.metod = ortalama 178ms

select getdate()

SELECT geEvrakID, doclangId, bilgiEdinme INTO #tosun FROM dbo.GelenEvrak;

drop table #tosun;

select getdate()

CURSOR FOR TEST: Kayıt Sayısı: 74387

SANAL TABLO İLE: SELECT * INTO #test FROM ...

CURSOR FORWARD_ONLY STATIC FOR

17:977 17:957 17:617 17:583

CURSOR FORWARD_ONLY FOR

19:557 19:670 19:360

CURSOR FAST_FORWARD FOR

18:197 18:147 18:977

NORMAL SELECT İLE: SELECT * FROM ...

CURSOR FORWARD_ONLY STATIC FOR

17:887 17:947 17:903 17:547

CURSOR FORWARD_ONLY FOR

19:087 19:220 19:697

CURSOR FAST_FORWARD FOR

17:877 17:823 17:817 18:047

CURSOR READ_ONLY FORWARD_ONLY STATIC FOR

17:513 17:417 17:563

CURSOR READ_ONLY FORWARD_ONLY FOR

17:697 17:797 18:267

SONUÇ: FORWARD_ONLY STATIC daha iyi gibi...