Datakent Forum : SQL Server CURSOR Test

Datakent Forum : SQL Server CURSOR Test http://forum.datakent.com/ XML içerik linki; Datakent Forum : Microsoft SQL Server : SQL Server CURSOR Test Fri, 01 May 2026 18:43:51 +0000 Sun, 19 Apr 2015 10:27:39 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.54 360 forum.datakent.com/RSS_post_feed.asp?TID=2787 Datakent Forum http://forum.datakent.com/forum_images/datakent.com_forums.png http://forum.datakent.com/ SQL Server CURSOR Test : SANAL TABLOYA VERİ EKLEME TEST:... http://forum.datakent.com/forum_posts.asp?TID=2787&PID=5628#5628 Yazar: murat turan
Konu: 2787
Gönderim Zamanı: 19.Nisan.2015 Saat 10:27

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...

]]> Sun, 19 Apr 2015 10:27:39 +0000 http://forum.datakent.com/forum_posts.asp?TID=2787&PID=5628#5628