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...
------------- http://www.kasatakip.com - Kasa Takip | http://www.caritakip.com - Cari Takip | http://www.evraktakip.com - Evrak Takip | http://www.etasqlmobil.com - ETA SQL Mobil
|