{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"PostgreSQL Sorgulama S\u0131ralamas\u0131 Tuza\u011f\u0131","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"TIdfqVNjut\"><a href=\"https:\/\/fatihsoysal.com\/blog\/postgresql-sorgulama-siralamasi-tuzagi\/\">PostgreSQL Sorgulama S\u0131ralamas\u0131 Tuza\u011f\u0131<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/postgresql-sorgulama-siralamasi-tuzagi\/embed\/#?secret=TIdfqVNjut\" width=\"600\" height=\"338\" title=\"&#8220;PostgreSQL Sorgulama S\u0131ralamas\u0131 Tuza\u011f\u0131&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"TIdfqVNjut\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"PostgreSQL, g\u00fc\u00e7l\u00fc ve esnek bir veritaban\u0131 y\u00f6netim sistemidir. Ancak, verimli sorgulamalar yazmak her zaman kolay de\u011fildir. Bu makalede, \u00f6zellikle s\u0131ralama i\u015flemlerinde (ORDER BY) s\u0131kl\u0131kla kar\u015f\u0131la\u015f\u0131lan tuzaklara ve bunlar\u0131n nas\u0131l \u00f6nlenece\u011fine dair ipu\u00e7lar\u0131 payla\u015faca\u011f\u0131m. \u00d6ncelikle, basit gibi g\u00f6r\u00fcnen bir s\u0131ralama i\u015fleminin bile beklenmedik sonu\u00e7lara yol a\u00e7abilece\u011fini hat\u0131rlatmak istiyorum. \u00d6rne\u011fin, b\u00fcy\u00fck veri k\u00fcmelerinde ORDER BY kullan\u0131m\u0131 performans\u0131 ciddi \u00f6l\u00e7\u00fcde etkileyebilir."}