{"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":"Geouzaml\u0131 \u0130ndeksleme: Bir \u00d6rnekleyici","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"2JIxT3jZgp\"><a href=\"https:\/\/fatihsoysal.com\/blog\/geouzamli-indeksleme-bir-ornekleyici\/\">Geouzaml\u0131 \u0130ndeksleme: Bir \u00d6rnekleyici<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/geouzamli-indeksleme-bir-ornekleyici\/embed\/#?secret=2JIxT3jZgp\" width=\"600\" height=\"338\" title=\"&#8220;Geouzaml\u0131 \u0130ndeksleme: Bir \u00d6rnekleyici&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"2JIxT3jZgp\" 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":"Merhaba! Fatih Soysal burada. Bu makalede, co\u011frafi konum verilerinin (\u00f6rne\u011fin, noktalar, \u00e7izgiler, poligonlar) veritabanlar\u0131nda etkili bir \u015fekilde indekslenmesi, yani geouzaml\u0131 indeksleme konusunu ele alaca\u011f\u0131z. \u00d6ncelikle, neden geouzaml\u0131 indekslemeye ihtiya\u00e7 duydu\u011fumuzu a\u00e7\u0131klayal\u0131m. Co\u011frafi verilerle \u00e7al\u0131\u015f\u0131rken, basit bir tablo taramas\u0131 performans a\u00e7\u0131s\u0131ndan son derece pahal\u0131 olabilir. B\u00fcy\u00fck veri k\u00fcmeleri s\u00f6z konusu oldu\u011funda, sorgular\u0131n cevaplanmas\u0131 saatler hatta g\u00fcnler s\u00fcrebilir. \u0130\u015fte bu noktada, geouzaml\u0131 indeksleme devreye girerek bu sorunu \u00e7\u00f6z\u00fcyor."}