{"id":73,"date":"2025-05-03T13:19:41","date_gmt":"2025-05-03T13:19:41","guid":{"rendered":"http:\/\/www.webmobkey.com\/blog\/?p=73"},"modified":"2025-11-16T10:23:24","modified_gmt":"2025-11-16T10:23:24","slug":"sql-serverda-sayfalama-islemleri-buyuk-veri-kumeleri-icin-performans-iyilestirme-yontemi","status":"publish","type":"post","link":"https:\/\/www.webmobdesign.com\/blog\/tr\/sql-serverda-sayfalama-islemleri-buyuk-veri-kumeleri-icin-performans-iyilestirme-yontemi\/","title":{"rendered":"SQL Server\u2019da Sayfalama \u0130\u015flemleri: B\u00fcy\u00fck Veri K\u00fcmeleri \u0130\u00e7in Performans \u0130yile\u015ftirme Y\u00f6ntemi"},"content":{"rendered":"\n

Bir veritaban\u0131 y\u00f6neticisi olarak, belirli bir sayfadan ba\u015flayarak belirli say\u0131da kayd\u0131 getirmenin performans\u0131n\u0131 iyile\u015ftiren bir SQL sorgusu kullanmay\u0131 \u00f6\u011frenmek \u00f6nemlidir. \u00d6zellikle b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in performans\u0131 etkileyen sayfalama i\u015flemleri, SQL Server\u2019da OFFSET<\/code> ve FETCH NEXT<\/code> \u00f6zellikleri kullan\u0131larak optimize edilebilir.<\/p>\n\n\n\n

Bu makalede, SQL Server\u2019da sayfalama i\u015flemlerinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini anlataca\u011f\u0131m. Bunun i\u00e7in, Northwind veritaban\u0131nda bulunan Orders<\/code> tablosunu kullanaca\u011f\u0131m.<\/p>\n\n\n\n

Orders<\/code> tablosundaki verileri s\u0131ralamak ve sayfalama i\u015flemini ger\u00e7ekle\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki SQL sorgusunu kullanabilirsiniz:<\/p>\n\n\n

\nDECLARE @page INT = 1;\nDECLARE @kayitSayisi INT = 10;\nSELECT [OrderID]\n      ,[CustomerID]\n      ,[EmployeeID]\n      ,[OrderDate]\n      ,[RequiredDate]\n      ,[ShippedDate]\n      ,[ShipVia]\n      ,[Freight]\n      ,[ShipName]\n      ,[ShipAddress]\n      ,[ShipCity]\n      ,[ShipRegion]\n      ,[ShipPostalCode]\n      ,[ShipCountry]\nFROM [Northwind].[dbo].[Orders]\nORDER BY OrderID\nOFFSET (@page - 1) * @kayitSayisi ROWS\nFETCH NEXT @kayitSayisi ROWS ONLY;\n<\/pre><\/div>\n\n\n
Bu sorgu, Orders<\/code> tablosundaki kay\u0131tlar\u0131 OrderID<\/code> s\u00fctununa g\u00f6re s\u0131ralar ve belirli bir sayfadan ba\u015flayarak belirli say\u0131da kayd\u0131 getirir. @page<\/code> ve @kayitSayisi<\/code> de\u011fi\u015fkenleri, hangi sayfa ve ka\u00e7 kay\u0131t getirilece\u011fini belirler.<\/p>\n\n\n\n
Sorguyu optimize etmek i\u00e7in, Orders<\/code> tablosunda OrderID<\/code> s\u00fctunu i\u00e7in bir indeks olu\u015fturman\u0131z \u00f6nerilir. Bu indeks, sorgunun h\u0131z\u0131n\u0131 art\u0131r\u0131r ve sayfalama i\u015fleminin daha h\u0131zl\u0131 ger\u00e7ekle\u015ftirilmesini sa\u011flar.<\/p>\n\n\n\n
Ayr\u0131ca, OFFSET<\/code> ve FETCH NEXT<\/code> \u00f6zelliklerinin yan\u0131 s\u0131ra, di\u011fer SQL Server optimizasyon tekniklerini de kullanabilirsiniz. Bunlar aras\u0131nda, WHERE<\/code> ifadesi ile sorguyu filtreleme, join i\u015flemlerinde gerekli s\u00fctunlar\u0131 se\u00e7me ve sorgu sonu\u00e7lar\u0131n\u0131 \u00f6nbellekleme bulunur.<\/p>\n\n\n\n
Sonu\u00e7 olarak, SQL Server\u2019da sayfalama i\u015flemlerinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi hakk\u0131nda bilgi sahibi olmak, b\u00fcy\u00fck veri k\u00fcmelerinde sorgular\u0131n performans\u0131n\u0131 optimize etmek i\u00e7in \u00f6nemlidir. OFFSET<\/code> ve FETCH NEXT<\/code> \u00f6zellikleri kullan\u0131larak bu i\u015flem basit ve h\u0131zl\u0131 bir \u015fekilde ger\u00e7ekle\u015ftirilebilir.<\/a><\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Bir veritaban\u0131 y\u00f6neticisi olarak, belirli bir sayfadan ba\u015flayarak belirli say\u0131da kayd\u0131 getirmenin performans\u0131n\u0131 iyile\u015ftiren bir SQL … SQL Server\u2019da Sayfalama \u0130\u015flemleri: B\u00fcy\u00fck Veri K\u00fcmeleri \u0130\u00e7in Performans \u0130yile\u015ftirme Y\u00f6ntemi<\/span>Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-73","post","type-post","status-publish","format-standard","hentry","category-sql-tr"],"_links":{"self":[{"href":"https:\/\/www.webmobdesign.com\/blog\/wp-json\/wp\/v2\/posts\/73","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webmobdesign.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webmobdesign.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webmobdesign.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webmobdesign.com\/blog\/wp-json\/wp\/v2\/comments?post=73"}],"version-history":[{"count":1,"href":"https:\/\/www.webmobdesign.com\/blog\/wp-json\/wp\/v2\/posts\/73\/revisions"}],"predecessor-version":[{"id":337,"href":"https:\/\/www.webmobdesign.com\/blog\/wp-json\/wp\/v2\/posts\/73\/revisions\/337"}],"wp:attachment":[{"href":"https:\/\/www.webmobdesign.com\/blog\/wp-json\/wp\/v2\/media?parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webmobdesign.com\/blog\/wp-json\/wp\/v2\/categories?post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webmobdesign.com\/blog\/wp-json\/wp\/v2\/tags?post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}