{"id":17041,"date":"2022-09-19T02:12:06","date_gmt":"2022-09-18T23:12:06","guid":{"rendered":"https:\/\/yeni.profelis.com.tr\/?page_id=17041"},"modified":"2025-06-30T11:55:22","modified_gmt":"2025-06-30T08:55:22","slug":"enterprisedb-performans","status":"publish","type":"page","link":"https:\/\/profelis.com.tr\/en\/enterprisedb-performans\/","title":{"rendered":"EnterpriseDB Performans"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"17041\" class=\"elementor elementor-17041\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-15f018b8 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"15f018b8\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;slideshow&quot;,&quot;background_slideshow_gallery&quot;:[{&quot;id&quot;:14784,&quot;url&quot;:&quot;https:\\\/\\\/profelis.com.tr\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/bg_links.png&quot;}],&quot;pix_scale_in&quot;:&quot;none&quot;,&quot;background_slideshow_loop&quot;:&quot;yes&quot;,&quot;background_slideshow_slide_duration&quot;:5000,&quot;background_slideshow_slide_transition&quot;:&quot;fade&quot;,&quot;background_slideshow_transition_duration&quot;:500}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-10c56960\" data-id=\"10c56960\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6627c6c1 elementor-invisible elementor-widget elementor-widget-pix-badge\" data-id=\"6627c6c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-badge.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<span class=\"pix-badge-element h6 d-inline-flex mr-1 animate-in\" data-anim-type=\"fade-in-up\" data-anim-delay=\"0\"><span class=\"badge font-weight-bold secondary-font  bg-red  \" style=\" \"><span class=\"text-white\" style=\"\">EDB Postgres Advanced Server<\/span><\/span><\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7799f672 elementor-widget elementor-widget-pix-sliding-text\" data-id=\"7799f672\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-sliding-text.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"el-7799f672\" class=\"mb-3 pix-sliding-text-element text-left \"><h1 class=\"mb-32 pix-sliding-headline-2 animate-in font-weight-bold secondary-font \" data-anim-type=\"pix-sliding-text\" data-class=\"secondary-font text-gray-1\" style=\"\"><span class=\"slide-in-container \"><span class=\"pix-sliding-item secondary-font text-gray-1\" style=\"transition-delay: 0ms;\">EDB&#32;<\/span><\/span> <span class=\"slide-in-container \"><span class=\"pix-sliding-item secondary-font text-gray-1\" style=\"transition-delay: 150ms;\">Postgres&#32;<\/span><\/span> <span class=\"slide-in-container \"><span class=\"pix-sliding-item secondary-font text-gray-1\" style=\"transition-delay: 300ms;\">Advanced&#32;<\/span><\/span> <span class=\"slide-in-container \"><span class=\"pix-sliding-item secondary-font text-gray-1\" style=\"transition-delay: 450ms;\">Server&#32;<\/span><\/span> <span class=\"slide-in-container \"><span class=\"pix-sliding-item secondary-font text-gray-1\" style=\"transition-delay: 600ms;\">Performans&#32;<\/span><\/span> <\/h1><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-72d366c7 elementor-invisible elementor-widget elementor-widget-pix-text\" data-id=\"72d366c7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-text.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"pix-el-text w-100 text-left \" ><p class=\"text-20 resp-option text-gray-1 text-left \" ><span class=\"text-gray-1 animate-in d-inline-block\" data-anim-delay=\"200\" data-anim-type=\"fade-in-up\">D\u00fcnyan\u0131n en geli\u015fmi\u015f a\u00e7\u0131k kaynak veritaban\u0131<\/span><\/p><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a4e358e elementor-widget elementor-widget-pix-button\" data-id=\"a4e358e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<span  class=\"btn m-0     shadow-inverse-lg shadow-inverse-hover-lg btn-blink-white d-inline-flex align-items-center pix-hover-item     secondary-font btn-rounded animate-in pix-popup-link btn-lg\"   data-anim-type=\"fade-in-up\" data-anim-delay=\"0\" data-popup-id=\"16768\"><i class=\"icon-postgresql font-weight-bold  pix-hover-left  mr-2\"><\/i><span class=\"font-weight-bold \" >Projelerinizle ilgili bize ula\u015f\u0131n<\/span><\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-1f2bff57\" data-id=\"1f2bff57\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3b38c38 elementor-widget elementor-widget-image\" data-id=\"3b38c38\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"102\" src=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/03\/edb_landscape_color_white-300x102.png\" class=\"attachment-medium size-medium wp-image-34315\" alt=\"\" srcset=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/03\/edb_landscape_color_white-300x102.png 300w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/03\/edb_landscape_color_white-1024x347.png 1024w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/03\/edb_landscape_color_white-768x260.png 768w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/03\/edb_landscape_color_white-1536x520.png 1536w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/03\/edb_landscape_color_white.png 1572w\" sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77bcbfc1 elementor-invisible elementor-widget elementor-widget-pix-img\" data-id=\"77bcbfc1\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\" data-widget_type=\"pix-img.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"el-77bcbfc1\" class=\"pix-img-element pix-img-div none text-center\" ><div class=\"animate-in d-inline-block\" data-anim-type=\"fade-in-up-big\" data-anim-delay=\"0\"><div class=\"pix-img-el     text-center d-inline-block   rounded-lg\"  data-jarallax-element=\"50 0\" data-xaxis=\"50\" data-yaxis=\"0\"><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6309eab0 elementor-section-stretched elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"6309eab0\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-30b48be0\" data-id=\"30b48be0\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4c501ce5 elementor-widget elementor-widget-pix-dividers\" data-id=\"4c501ce5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-dividers.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"pix-divider  position-relative pix-bottom-divider\" data-style=\"style-19\" ><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"100%\" height=\"300px\" viewBox=\"0 0 1200 415\" preserveAspectRatio=\"none\"><g class=\"animate-in\" data-anim-type=\"fade-in-up\" data-anim-delay=\"0\"><path class=\"pix-divider-layer-3\" fill=\"rgba(255, 255, 255, 0.3)\"  d=\"M5.68434189e-13,292.788567 C80.6666667,271.41188 159.333333,260.723537 236,260.723537 C421,260.723537 525,344.759008 670,273.729027 C788.879994,215.494242 940.849865,-5.02123357 1200,0.788566864 C1200,33.4552335 1200,171.525711 1200,415 L9.19819776e-13,414.788567 L5.68434189e-13,292.788567 Z\"  \/><\/g><g class=\"animate-in\" data-anim-type=\"fade-in-up\" data-anim-delay=\"0\"><path class=\"pix-divider-layer-2\" fill=\"rgba(255, 255, 255, 0.6)\"  d=\"M2.08355555e-12,332.788567 C80.6666667,284.745214 159.333333,260.723537 236,260.723537 C421,260.723537 525,344.759008 670,273.729027 C789.08369,215.39446 940.387018,21.5609115 1200,37.7885669 C1200,55.7885669 1200,181.525711 1200,415 L1.8189894e-12,414.788567 L2.08355555e-12,332.788567 Z\" \/><\/g><path class=\"pix-divider-layer-1\" fill=\"#ffffff\" d=\"M9.09494702e-13,373.771254 C80.6666667,298.406109 159.333333,260.723537 236,260.723537 C421,260.723537 525,344.759008 670,273.729027 C789.088175,215.392262 940.369069,48.85905 1200,74.7885669 C1200,148.788567 1200,262.192378 1200,415 L1.0227342e-12,414.788567 L9.09494702e-13,373.771254 Z\"\/><defs><\/defs><\/svg><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c36d79a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c36d79a\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-390d162\" data-id=\"390d162\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-d394489 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d394489\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-f30b683\" data-id=\"f30b683\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-47d7ad5 elementor-widget elementor-widget-lightbox\" data-id=\"47d7ad5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"lightbox.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t        <div id=\"bdt-lightbox-47d7ad5\" class=\"bdt-lightbox-wrapper\">              \n\t\t\t<div data-bdt-lightbox=\" animation: slide; video-autoplay: true;\">\t\t\t\n\n\t\t\t    <a data-elementor-open-lightbox=\"no\" data-caption=\"This is a image\" href=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/pem-tuning-wizard.png\">\n\n\t\t\t    \t\t\t\t\t\t\t<div class=\"bdt-toggler-poster bdt-background-cover\" style=\"background-image: url('https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/pem-tuning-wizard-936x1024.png');\"><\/div>\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t\t    \t<\/a>\n\n\t\t\t\t\n\t\t\t<\/div>     \n        <\/div>\n        \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f5cae1 elementor-widget elementor-widget-pix-text\" data-id=\"9f5cae1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-text.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"pix-el-text w-100 text-center \" ><p class=\" resp-option text-body-default text-center font-weight-bold\" >Daha fazla bilgi almaya m\u0131 ihtiyac\u0131n\u0131z var?<\/p><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4af0f36 elementor-widget elementor-widget-pix-button\" data-id=\"4af0f36\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"d-block w-100 text-center\"><span  class=\"btn m-0      btn-underline-red d-inline-flex align-items-center pix-hover-item  no-padding     pix-popup-link pix-btn-div btn-lg\"     data-popup-id=\"16768\"><span class=\"font-weight-bold \" >Bizimle ileti\u015fime ge\u00e7in<\/span><svg class=\"pixfort-icon font-weight-bold  pix-hover-right  ml-2\" width=\"24\" height=\"24\"  data-name=\"Line\/pixfort-icon-arrow-right-circle-2\" viewBox=\"2 2 20 20\"><path fill=\"none\" stroke=\"var(--pf-icon-color)\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"var(--pf-icon-stroke-width)\" d=\"M12,21 C16.9705627,21 21,16.9705627 21,12 C21,7.02943725 16.9705627,3 12,3 C7.02943725,3 3,7.02943725 3,12 C3,16.9705627 7.02943725,21 12,21 Z M10.5,8 L14.5,12 L10.5,16\"\/><\/svg><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-cf680c9\" data-id=\"cf680c9\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ef98893 elementor-widget elementor-widget-pix-icon\" data-id=\"ef98893\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"duo-icon-171792622\" class=\"pix-icon text-left \"><div class=\"pix-icon-bg rounded-circle feature_img position-relative d-inline-flex align-items-center justify-content-center bg-red \"   style=\" width:64px;height:64px;position:relative;line-height:64px;text-align:center;\"><span style=\"font-size:36px;line-height:36px;\" class=\"text-white d-inline-flex align-middle\"><svg class=\"pixfort-icon \" width=\"36\" height=\"36\"  data-name=\"Duotone\/pixfort-icon-bolt-3\" viewBox=\"2 2 20 20\"><g fill=\"none\" fill-rule=\"evenodd\"><path fill=\"var(--pf-icon-color)\" fill-opacity=\".25\" d=\"M11,6 C11.5522847,6 12,6.44771525 12,7 C12,7.55228475 11.5522847,8 11,8 L5,8 C4.44771525,8 4,7.55228475 4,7 C4,6.44771525 4.44771525,6 5,6 L11,6 Z M8,11 C8.55228475,11 9,11.4477153 9,12 C9,12.5522847 8.55228475,13 8,13 L3,13 C2.44771525,13 2,12.5522847 2,12 C2,11.4477153 2.44771525,11 3,11 L8,11 Z M11,16 C11.5522847,16 12,16.4477153 12,17 C12,17.5522847 11.5522847,18 11,18 L5,18 C4.44771525,18 4,17.5522847 4,17 C4,16.4477153 4.44771525,16 5,16 L11,16 Z\"\/><path fill=\"var(--pf-icon-color)\" d=\"M16.1759581,4.43347118 L10.6759581,12.4334712 L10.6170624,12.5297632 C10.2657894,13.1809277 10.7331624,14 11.5,14 L13.999,14 L14,19 C14,19.9713329 15.2451104,20.3723733 15.8120154,19.583636 L21.5620154,11.583636 L21.6235586,11.487482 C21.9917133,10.8363437 21.5259261,10 20.75,10 L17.999,10 L18,5 C18,4.01795609 16.7323143,3.62422582 16.1759581,4.43347118 Z\"\/><\/g><\/svg><\/span><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e023a1f elementor-widget elementor-widget-text-editor\" data-id=\"e023a1f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>EnterpriseDB size ve kurumunuza PostgreSQL veri tabanlar\u0131n\u0131 kullanabilmeniz, verinizi PostgreSQL\u2019e ta\u015f\u0131yabilmeniz (g\u00f6\u00e7) i\u00e7in; <span style=\"color: #ff6600;\">veri korumas\u0131, yedekleme, performans geli\u015ftirme ve felaket y\u00f6netimi gibi \u00fcst d\u00fczey \u00f6zellikler i\u00e7in \u00f6zel ara\u00e7lar<\/span> sa\u011flamaktad\u0131r.<\/p><p>Burada sadece bir k\u0131s\u0131m \u00f6ne \u00e7\u0131kan PAS Performans geli\u015ftirmeleri ele al\u0131nm\u0131\u015ft\u0131r.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c9337cb elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c9337cb\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-b7aab09\" data-id=\"b7aab09\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-77ba1d4 shadow-sm bg-white fly-sm rounded-xl sticky-top pix-sticky-top-adjust position-sticky animated-fast elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"77ba1d4\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;animation&quot;:&quot;none&quot;,&quot;animation_delay&quot;:200,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-7866362\" data-id=\"7866362\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b4cba47 elementor-widget elementor-widget-heading\" data-id=\"b4cba47\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Sorgu Optimizasyon \u0130pu\u00e7lar\u0131<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dd15dc8 elementor-widget elementor-widget-text-editor\" data-id=\"dd15dc8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"color: #ff6600;\"><b>Query Optimizer Hints<\/b>\u00a0<\/span>yaz\u0131l\u0131m geli\u015ftiricilerinin, dahili SQL Optimizasyoncusuna optimizasyon yaparken nas\u0131l davranaca\u011f\u0131na y\u00f6nelik katk\u0131da bulunmalar\u0131n\u0131 sa\u011flar. Zira baz\u0131 durumlarda verinin yap\u0131s\u0131n\u0131 yaz\u0131l\u0131m geli\u015ftirici bilir ama SQL Optimizasyoncusu bilmez. \u00d6rne\u011fin yaz\u0131l\u0131mc\u0131 bir indeksin o sorgu i\u00e7in daha se\u00e7ici oldu\u011funu biliyor olabilir.<\/p><p>Sorgular\u0131n yaz\u0131l\u0131m\u0131n ihtiya\u00e7lar\u0131na uygun plan ile \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131 ve optimizasyonu i\u00e7in bir\u00e7ok ipucu mevcuttur. Sorgu baz\u0131 sat\u0131rlar\u0131 h\u0131zl\u0131ca getirmek \u00fczere belirli bir plan ile i\u015fletilmek \u00fczere y\u00f6nlendirilebilir veya belirli bir join kullanmak \u00fczere optimize edilebilir.<\/p><p>Sorgu Optimizasyon \u0130pu\u00e7lar\u0131 <span style=\"color: #ff6600;\">yaz\u0131l\u0131m geli\u015ftiricilerine ek esneklikler ve sorgu i\u015fletim esnas\u0131nda ek kontrol g\u00fcc\u00fc<\/span> sa\u011flayarak, uygulaman\u0131n her daim <span style=\"color: #ff6600;\">belirli, kararl\u0131 bir performans\u0131 yakalamas\u0131n\u0131<\/span> sa\u011flar.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-694ff90 elementor-widget elementor-widget-pix-button\" data-id=\"694ff90\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"d-block w-100 text-center\"><span  class=\"btn m-0      btn-primary btn-flat d-inline-flex align-items-center pix-hover-item       animate-in pix-popup-link pix-btn-div btn-lg\"   data-anim-type=\"fade-in-up\" data-anim-delay=\"500\" data-popup-id=\"16768\"><span class=\"font-weight-bold \" >\u0130htiya\u00e7lar\u0131n\u0131z\u0131 g\u00f6r\u00fc\u015felim<\/span><svg class=\"pixfort-icon font-weight-bold  pix-hover-right  ml-2\" width=\"24\" height=\"24\"  data-name=\"Line\/pixfort-icon-arrow-right-circle-1\" viewBox=\"2 2 20 20\"><path fill=\"none\" stroke=\"var(--pf-icon-color)\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"var(--pf-icon-stroke-width)\" d=\"M12,21 C16.9705627,21 21,16.9705627 21,12 C21,7.02943725 16.9705627,3 12,3 C7.02943725,3 3,7.02943725 3,12 C3,16.9705627 7.02943725,21 12,21 Z M7,12 L16,12 M12,17 L17,12 L12,7\"\/><\/svg><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-1821271\" data-id=\"1821271\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"sticky-top pix-sticky-top-adjust elementor-section elementor-inner-section elementor-element elementor-element-8b6cf59 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8b6cf59\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-2393b84\" data-id=\"2393b84\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ffc4a41 elementor-widget elementor-widget-lightbox\" data-id=\"ffc4a41\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"lightbox.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t        <div id=\"bdt-lightbox-ffc4a41\" class=\"bdt-lightbox-wrapper\">              \n\t\t\t<div data-bdt-lightbox=\" animation: slide; video-autoplay: true;\">\t\t\t\n\n\t\t\t    <a data-elementor-open-lightbox=\"no\" data-caption=\"This is a image\" href=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/ppas-query-optimizer-hints-1200x884-1.png\">\n\n\t\t\t    \t\t\t\t\t\t\t<div class=\"bdt-toggler-poster bdt-background-cover\" style=\"background-image: url('https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/ppas-query-optimizer-hints-1200x884-1-1024x754.png');\"><\/div>\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t\t    \t<\/a>\n\n\t\t\t\t\n\t\t\t<\/div>     \n        <\/div>\n        \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-01f9a7c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"01f9a7c\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5b12249\" data-id=\"5b12249\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ddb5c87 elementor-widget elementor-widget-bdt-table\" data-id=\"ddb5c87\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"bdt-table.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"bdt-table bdt-table-default-responsive bdt-stripe\" id=\"bdt-table-ddb5c87\">\n\n\n\t\t\t\n\t\t<table class=\"bdt-static-table\">\n\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t\n\t\t\t\t\t\t<th class=\"bdt-static-column-cell elementor-repeater-item-a5e9a6c\">\n\t\t\t\t\t\t\t<div class=\"bdt-static-column-cell-wrap\">\n\n\t\t\t\t\t\t\t\t<div class=\"bdt-static-column-cell-text\">\n\t\t\t\t\t\t\t\t\tSorgu \u0130pucu\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/th>\n\n\t\t\t\t\t\n\t\t\t\t\t\t<th class=\"bdt-static-column-cell elementor-repeater-item-74ce5a1\">\n\t\t\t\t\t\t\t<div class=\"bdt-static-column-cell-wrap\">\n\n\t\t\t\t\t\t\t\t<div class=\"bdt-static-column-cell-text\">\n\t\t\t\t\t\t\t\t\tA\u00e7\u0131klama\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/th>\n\n\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t<\/thead>\n\n\t\t\t<tbody>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-1c64d29\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tALL_ROWS\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-a8cac73\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tSonu\u00e7 k\u00fcmesinden t\u00fcm sat\u0131rlar\u0131 getirmek \u00fczere optimize\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-b683c8b\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tCHOOSE\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-d4780b7\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tVarsay\u0131lan durum. Sonu\u00e7 k\u00fcmesinden belirli miktarda sat\u0131r\u0131 getirmek \u00fczere herhangi bir optimizasyon i\u00e7ermez\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-080d830\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tFIRST_ROWS\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-73105c4\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tSonu\u00e7 k\u00fcmesinden ilk sat\u0131r\u0131 getirmek \u00fczere optimize\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-c5d508e\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tFIRST_ROWS_10\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-c582818\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tSonu\u00e7 k\u00fcmesinden ilk 10 sat\u0131r\u0131 getirmek \u00fczere optimize\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-919754a\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tFIRST_ROWS_100\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-67c7a1e\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tSonu\u00e7 k\u00fcmesinden ilk 100 sat\u0131r\u0131 getirmek \u00fczere optimize\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-96bd714\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tFIRST_ROWS_1000\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-0d1b9b9\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tSonu\u00e7 k\u00fcmesinden ilk 1000 sat\u0131r\u0131 getirmek \u00fczere optimize\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-dbc99f7\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tFIRST_ROWS(n)\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-14d58f4\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tSonu\u00e7 k\u00fcmesinden ilk [n] sat\u0131r\u0131 getirmek \u00fczere optimize\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-d4c24bf\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tFULL(table)\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-e2e0dc1\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tTabloda s\u0131ral\u0131 bir tam tarama ger\u00e7ekle\u015ftirir\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-3daaee9\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tINDEX(table[ index] [\u2026])\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-36554f3\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\t\u0130li\u015fkiye eri\u015fim i\u00e7in tablodaki [index]\u2019i kullan\u0131r\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-7b36175\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tNO_INDEX(table [ index] [\u2026])\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-7a1957c\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\t\u0130li\u015fkiye eri\u015fim i\u00e7in tablodaki [index]\u2019i kullanmaz\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-55a826b\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tUSE_HASH(table [\u2026])\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-cd3b5bd\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tTablosunun join niteliklerini kullanarak olu\u015fturulan bir hash\u2019i kullan\u0131r\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-265ede6\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tNO_USE_HASH(table [\u2026])\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-66ad7f3\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tTablosunun join niteliklerini kullanarak olu\u015fturulan bir hash\u2019i kullanmaz\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-0d80363\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tUSE_MERGE(table [\u2026])\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-ede0332\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tJoin tablosu i\u00e7in birle\u015ftirilmi\u015f s\u0131ralama kullan\u0131r\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-420fff7\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tNO_USE_MERGE(table [\u2026])\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-7dc6650\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tJoin tablosu i\u00e7in birle\u015ftirilmi\u015f s\u0131ralama kullanmaz.\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-a067f80\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tUSE_NL(table [\u2026])\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-1c8886c\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tTablo i\u00e7in i\u00e7i\u00e7e ge\u00e7mi\u015f (nested loop) d\u00f6ng\u00fc kullan\u0131r\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-2dc440f\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tNO_USE_NL(table [\u2026])\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td class=\"bdt-static-body-row-cell elementor-repeater-item-a0ef798\">\n\n\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-wrap\">\n\t\t\t\t\t\t\t\t\t\t<div class=\"bdt-static-body-row-cell-text\">\n\t\t\t\t\t\t\t\t\t\t\tTablo i\u00e7in i\u00e7i\u00e7e ge\u00e7mi\u015f (nested loop) d\u00f6ng\u00fc kullanmaz\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t<\/tbody>\n\n\t\t<\/table>\n\n\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-49ae0b96 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"49ae0b96\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8dd0d54\" data-id=\"8dd0d54\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-84a6a40 shadow-sm bg-white fly-sm rounded-xl sticky-top pix-sticky-top-adjust position-sticky animated-fast elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"84a6a40\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;animation&quot;:&quot;none&quot;,&quot;animation_delay&quot;:200,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-78ec0ee\" data-id=\"78ec0ee\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-88d14f1 elementor-invisible elementor-widget elementor-widget-pix-badge\" data-id=\"88d14f1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-badge.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"pix-element-div w-100 text-center\"><span class=\"pix-badge-element h6 d-inline-flex mr-1 animate-in\" data-anim-type=\"fade-in-up\" data-anim-delay=\"0\"><span class=\"badge font-weight-bold secondary-font  bg-red  \" style=\" \"><span class=\"text-white\" style=\"\">PAS Performans<\/span><\/span><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9e67d73 elementor-widget elementor-widget-pix-icon\" data-id=\"9e67d73\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"duo-icon-195986601\" class=\"pix-icon text-left \"><div class=\"pix-icon-bg rounded-circle feature_img position-relative d-inline-flex align-items-center justify-content-center bg-red \"   style=\" width:64px;height:64px;position:relative;line-height:64px;text-align:center;\"><span style=\"font-size:36px;line-height:36px;\" class=\"text-white d-inline-flex align-middle\"><svg class=\"pixfort-icon \" width=\"36\" height=\"36\"  data-name=\"Duotone\/pixfort-icon-arrows-shuffle-1\" viewBox=\"2 2 20 20\"><g fill=\"none\" fill-rule=\"evenodd\"><path fill=\"var(--pf-icon-color)\" fill-opacity=\".25\" d=\"M19.5,3.5 C20.0522847,3.5 20.5,3.94771525 20.5,4.5 C20.5,7.26826114 19.1235451,8.88896643 15.83219,10.9896075 L14.0045809,12.1264429 C10.1483549,14.5493663 8.45402334,16.590362 8.4379419,20.1455729 L9.79289322,18.7928932 C10.1533772,18.4324093 10.7206082,18.4046797 11.1128994,18.7097046 L11.2071068,18.7928932 C11.5976311,19.1834175 11.5976311,19.8165825 11.2071068,20.2071068 L8.20710678,23.2071068 C7.81658249,23.5976311 7.18341751,23.5976311 6.79289322,23.2071068 L3.79289322,20.2071068 C3.40236893,19.8165825 3.40236893,19.1834175 3.79289322,18.7928932 C4.18341751,18.4023689 4.81658249,18.4023689 5.20710678,18.7928932 L6.43710036,20.0222235 C6.48129938,15.8370396 8.47890803,13.3016771 12.6099768,10.6431461 L14.4580011,9.4920017 C17.4362226,7.63061324 18.5,6.4429006 18.5,4.5 C18.5,3.94771525 18.9477153,3.5 19.5,3.5 Z\" transform=\"rotate(-90 12 13.5)\"\/><path fill=\"var(--pf-icon-color)\" d=\"M19.5,0.5 C20.0522847,0.5 20.5,0.94771525 20.5,1.5 C20.5,4.26826114 19.1235451,5.88896643 15.83219,7.98960748 L14.0045809,9.12644285 C10.1483549,11.5493663 8.45402334,13.590362 8.4379419,17.1455729 L9.79289322,15.7928932 C10.1533772,15.4324093 10.7206082,15.4046797 11.1128994,15.7097046 L11.2071068,15.7928932 C11.5976311,16.1834175 11.5976311,16.8165825 11.2071068,17.2071068 L8.20710678,20.2071068 C7.81658249,20.5976311 7.18341751,20.5976311 6.79289322,20.2071068 L3.79289322,17.2071068 C3.40236893,16.8165825 3.40236893,16.1834175 3.79289322,15.7928932 C4.18341751,15.4023689 4.81658249,15.4023689 5.20710678,15.7928932 L6.43710036,17.0222235 C6.48129938,12.8370396 8.47890803,10.3016771 12.6099768,7.64314613 L14.4580011,6.4920017 C17.4362226,4.63061324 18.5,3.4429006 18.5,1.5 C18.5,0.94771525 18.9477153,0.5 19.5,0.5 Z\" transform=\"matrix(0 1 1 0 1.5 -1.5)\"\/><\/g><\/svg><\/span><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-359aed9 elementor-widget elementor-widget-heading\" data-id=\"359aed9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">EDB*Loader ile H\u0131zl\u0131 Veri Aktar\u0131m\u0131<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f982ba elementor-widget elementor-widget-text-editor\" data-id=\"9f982ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>EDB*Loader\u2019\u0131n text dosyalar\u0131 Postgres veritaban\u0131na al\u0131rken performans\u0131 art\u0131r\u0131c\u0131 \u00f6zellikleri mevcuttur.<\/p><p>PostgreSQL\u2019in standard\u0131\u00a0<span style=\"color: #ff6600;\"><strong>COPY<\/strong><\/span>\u00a0komutudur, ancak y\u00fckleme zaman\u0131n\u0131 art\u0131ran \u00f6nemli limitleri vard\u0131r. Bunlardan ilki, sabit geni\u015flikli dosyalar\u0131 al\u0131rken bunlar\u0131n \u00f6nce ayr\u0131lm\u0131\u015f (\u00f6rne\u011fin virg\u00fcl ile) dosya haline getirilmesi gereklili\u011fidir.<\/p><p>\u201cCOPY\u201d komutunun di\u011fer \u00f6nemli limitasyonu ise <span style=\"color: #ff6600;\">hata kontrol\u00fcn\u00fcn olmamas\u0131d\u0131r<\/span>. \u201cCOPY\u201d komutu kullan\u0131ld\u0131\u011f\u0131nda, dosyadaki tek bir sat\u0131r hatal\u0131 ise geri kalanlar\u0131n aktar\u0131m\u0131n\u0131n da yap\u0131lamamas\u0131, dosyan\u0131n incelenerek yeniden d\u00fczeltimesinin gereklili\u011fidir.<\/p><p><span style=\"color: #ff6600;\">EDB*Loader ise bu sat\u0131rlar\u0131 g\u00f6zard\u0131 edilenler olarak farkl\u0131 bir dosyaya atar<\/span> ve sadece bu sat\u0131rlar\u0131n d\u00fczeltilerek yeniden y\u00fcklenmesini sa\u011flar. Di\u011fer sat\u0131rlar ise sisteme al\u0131n\u0131r.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-46007e4\" data-id=\"46007e4\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-44fab71 elementor-widget elementor-widget-heading\" data-id=\"44fab71\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">Direct Path, Paralel \u00c7al\u0131\u015fma ve Append<\/h5>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc5ab3c elementor-widget elementor-widget-text-editor\" data-id=\"cc5ab3c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Di\u011fer taraftan EDB*Loader\u2019\u0131n sa\u011flad\u0131\u011f\u0131 en \u00f6nemli avantaj, y\u00fckleme performans\u0131n\u0131 \u00e7ok fazla art\u0131ran \u201cDirect Path\u201d y\u00fcklemesidir. Direct Path y\u00fcklemesi, toplu dosya i\u015fleme aktarma performans\u0131n\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde etkileyen, yava\u015flatan baz\u0131 i\u015flemlerin bypass edilmesini sa\u011flarken, kullan\u0131c\u0131ya hepsini i\u015flet veya hata varsa hi\u00e7biri alma se\u00e7ene\u011fini de sunar.<\/p><p>Direct Path y\u00fcklemesi i\u015flenen sat\u0131rlar\u0131 ele alarak, bir kontrol dosyas\u0131nda sunulan s\u00fctun \u00f6zelliklerine g\u00f6re ayr\u0131\u015ft\u0131r\u0131r. Ayr\u0131\u015ft\u0131rd\u0131\u011f\u0131 veriyi daha sonra s\u00fct\u00fcn veri tipine \u00e7evirerek dahili bir veri yap\u0131s\u0131 olu\u015fturup bunu do\u011frudan Postgres veri blo\u011fu format\u0131na \u00e7evirerek i\u00e7eri al\u0131r.Do\u011frudan veri dizinine yaz\u0131lan bu i\u015flenmi\u015f veri blo\u011fu sayesinde y\u00fcksek i\u00e7eri alma performans\u0131 sa\u011flan\u0131r.<\/p><p>PAS 9.0 s\u00fcr\u00fcm\u00fcnden itibaren EDB*Loader\u2019a ayn\u0131 tabloya birden fazla dosyadan ayn\u0131 anda i\u00e7eri aktar\u0131m yetene\u011fi kazand\u0131r\u0131lm\u0131\u015f ve b\u00f6ylece i\u00e7eri aktar\u0131m performans\u0131nda \u00e7ok daha ileri kazan\u0131mlar sa\u011flanm\u0131\u015ft\u0131r. Paralel y\u00fckleme \u00f6zelli\u011fi art\u0131k\u00a0<strong><span style=\"color: #ff6600;\">EDB<\/span> <span style=\"color: #ff6600;\">Migration<\/span><\/strong>\u00a0Ara\u00e7lar\u0131 i\u00e7erisine de al\u0131nm\u0131\u015ft\u0131r ve bu sayede veri g\u00f6\u00e7\u00fc i\u015flemlerinin daha h\u0131zl\u0131 yap\u0131lmas\u0131 sa\u011flanm\u0131\u015ft\u0131r.<\/p><p>EDB*Loader ile i\u00e7eri aktar\u0131mlar s\u0131ras\u0131nda kullanabilece\u011finiz\u00a0<span style=\"color: #ff6600;\"><strong>APPEND<\/strong><\/span>\u00a0se\u00e7ene\u011fi sayesinde hedef tablonun bo\u015f olmas\u0131n\u0131 da gerektirmez.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-12d6386 elementor-widget elementor-widget-pix-button\" data-id=\"12d6386\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"d-block w-100 text-center\"><span  class=\"btn m-0      btn-primary btn-flat d-inline-flex align-items-center pix-hover-item       animate-in pix-popup-link pix-btn-div btn-lg\"   data-anim-type=\"fade-in-up\" data-anim-delay=\"500\" data-popup-id=\"16768\"><span class=\"font-weight-bold \" >\u0130htiya\u00e7lar\u0131n\u0131z\u0131 g\u00f6r\u00fc\u015felim<\/span><svg class=\"pixfort-icon font-weight-bold  pix-hover-right  ml-2\" width=\"24\" height=\"24\"  data-name=\"Line\/pixfort-icon-arrow-right-circle-1\" viewBox=\"2 2 20 20\"><path fill=\"none\" stroke=\"var(--pf-icon-color)\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"var(--pf-icon-stroke-width)\" d=\"M12,21 C16.9705627,21 21,16.9705627 21,12 C21,7.02943725 16.9705627,3 12,3 C7.02943725,3 3,7.02943725 3,12 C3,16.9705627 7.02943725,21 12,21 Z M7,12 L16,12 M12,17 L17,12 L12,7\"\/><\/svg><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"pix-elementor-divider elementor-section elementor-top-section elementor-element elementor-element-3aad66b elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3aad66b\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-9cce058\" data-id=\"9cce058\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"sticky-top pix-sticky-top-adjust elementor-section elementor-inner-section elementor-element elementor-element-15698f5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"15698f5\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-4d1d098\" data-id=\"4d1d098\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-af1473c elementor-widget elementor-widget-lightbox\" data-id=\"af1473c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"lightbox.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t        <div id=\"bdt-lightbox-af1473c\" class=\"bdt-lightbox-wrapper\">              \n\t\t\t<div data-bdt-lightbox=\" animation: slide; video-autoplay: true;\">\t\t\t\n\n\t\t\t    <a data-elementor-open-lightbox=\"no\" data-caption=\"This is a image\" href=\"https:\/\/yeni.profelis.com.tr\/wp-content\/uploads\/2022\/09\/sp_create_new_trace.png\">\n\n\t\t\t    \t\t\t\t\t\t\t<div class=\"bdt-toggler-poster bdt-background-cover\" style=\"background-image: url('https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/sp_create_new_trace.png');\"><\/div>\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\t\t    \t<\/a>\n\n\t\t\t\t\n\t\t\t<\/div>     \n        <\/div>\n        \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-cbae962\" data-id=\"cbae962\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-7139f50 shadow-sm bg-white fly-sm rounded-xl sticky-top pix-sticky-top-adjust position-sticky animated-fast elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7139f50\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;animation&quot;:&quot;none&quot;,&quot;animation_delay&quot;:200,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-9bc3b84\" data-id=\"9bc3b84\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cae9f24 elementor-widget elementor-widget-heading\" data-id=\"cae9f24\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">SQL Profilcisi<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b41439c elementor-widget elementor-widget-text-editor\" data-id=\"b41439c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-10 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-last gradient-column-11 fusion-column-no-min-height\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-5\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-14 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-first gradient-column-15\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-14\"><p>Postgres Advanced Server, Postgres Enterprise Manager i\u00e7erisinde gelen bir SQL Profiler i\u00e7ermektedir.<\/p><p>SQL Profiler se\u00e7ilen veritaban\u0131n\u0131 inceleyerek buraya gelen SQL komutlar\u0131n\u0131n raporunu \u00e7\u0131kart\u0131r. orgu profili raporu, veritaban\u0131 uzmanlar\u0131na sistemlerinin veya yaz\u0131l\u0131mlar\u0131n\u0131n performans\u0131n\u0131 art\u0131rmada en b\u00fcy\u00fck yard\u0131mc\u0131lardan birisidir.<\/p><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-15 fusion_builder_column_1_2 1_2 fusion-one-half fusion-column-last gradient-column-16\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-15\"><p>Sorgu profil raporlar\u0131 iki temel ama\u00e7 i\u00e7in kullan\u0131labilir:<\/p><ul><li>\u0130\u015fletimi uzun s\u00fcren sorgular\u0131n tespit edilerek yeniden optimize edilmesi ile performans art\u0131\u015f\u0131<\/li><li>S\u00fcrekli tekrarlanan SQL komutlar\u0131 veya zaman al\u0131c\u0131 i\u015flemler i\u00e7eren fonksiyonlar\u0131n tespiti ve optimizasyonu ile performans art\u0131\u015f\u0131<\/li><\/ul><\/div><\/div><\/div><\/div><\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-217b126 elementor-widget elementor-widget-pix-button\" data-id=\"217b126\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"d-block w-100 text-center\"><span  class=\"btn m-0      btn-primary btn-flat d-inline-flex align-items-center pix-hover-item       animate-in pix-popup-link pix-btn-div btn-lg\"   data-anim-type=\"fade-in-up\" data-anim-delay=\"500\" data-popup-id=\"16768\"><span class=\"font-weight-bold \" >\u0130htiya\u00e7lar\u0131n\u0131z\u0131 g\u00f6r\u00fc\u015felim<\/span><svg class=\"pixfort-icon font-weight-bold  pix-hover-right  ml-2\" width=\"24\" height=\"24\"  data-name=\"Line\/pixfort-icon-arrow-right-circle-1\" viewBox=\"2 2 20 20\"><path fill=\"none\" stroke=\"var(--pf-icon-color)\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"var(--pf-icon-stroke-width)\" d=\"M12,21 C16.9705627,21 21,16.9705627 21,12 C21,7.02943725 16.9705627,3 12,3 C7.02943725,3 3,7.02943725 3,12 C3,16.9705627 7.02943725,21 12,21 Z M7,12 L16,12 M12,17 L17,12 L12,7\"\/><\/svg><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<div class=\"pix-divider  position-relative pix-bottom-divider elementor-element elementor-element-3aad66b pix-stretch-divider\" data-style=\"style-6\" ><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"100%\"  viewBox=\"0 0 1200 116\" preserveAspectRatio=\"none\"><path class=\"pix-divider-layer-3\" fill=\"rgba(255,255,255,0.3)\"  d=\"M0,50 C200,16.6666667 400,7.10542736e-15 600,7.10542736e-15 C800,7.10542736e-15 1000,16.6666667 1200,50 L1200,116 L0,116 L0,50 Z\"  \/><path class=\"pix-divider-layer-2\" fill=\"rgba(255,255,255,0.6)\"  d=\"M0,80 C200,46.6666667 400,30 600,30 C800,30 1000,46.6666667 1200,80 L1200,116 L0,116 L0,80 Z\" \/><path class=\"pix-divider-layer-1\" fill=\"#ffffff\" d=\"M0,110 C200,76.6666667 400,60 600,60 C800,60 1000,76.6666667 1200,110 L1200,116 L0,116 L0,110 Z\"\/><defs><\/defs><\/svg><\/div>\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-53c2410 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"53c2410\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dbd3229\" data-id=\"dbd3229\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-21c1535 shadow-sm bg-white fly-sm rounded-xl sticky-top pix-sticky-top-adjust position-sticky animated-fast elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21c1535\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;animation&quot;:&quot;none&quot;,&quot;animation_delay&quot;:200,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-2ecc89a\" data-id=\"2ecc89a\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0a7c200 elementor-invisible elementor-widget elementor-widget-pix-badge\" data-id=\"0a7c200\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-badge.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"pix-element-div w-100 text-center\"><span class=\"pix-badge-element h6 d-inline-flex mr-1 animate-in\" data-anim-type=\"fade-in-up\" data-anim-delay=\"0\"><span class=\"badge font-weight-bold secondary-font  bg-red  \" style=\" \"><span class=\"text-white\" style=\"\">PAS Performans<\/span><\/span><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e6e1398 elementor-widget elementor-widget-pix-icon\" data-id=\"e6e1398\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"duo-icon-140667927\" class=\"pix-icon text-left \"><div class=\"pix-icon-bg rounded-circle feature_img position-relative d-inline-flex align-items-center justify-content-center bg-red \"   style=\" width:64px;height:64px;position:relative;line-height:64px;text-align:center;\"><span style=\"font-size:36px;line-height:36px;\" class=\"text-white d-inline-flex align-middle\"><svg class=\"pixfort-icon \" width=\"36\" height=\"36\"  data-name=\"Duotone\/pixfort-icon-download-2\" viewBox=\"2 2 20 20\"><g fill=\"none\" fill-rule=\"evenodd\"><path fill=\"var(--pf-icon-color)\" fill-opacity=\".25\" d=\"M21,16 C21.5522847,16 22,16.4477153 22,17 L22,19 C22,20.6568542 20.6568542,22 19,22 L5,22 C3.34314575,22 2,20.6568542 2,19 L2,17 C2,16.4477153 2.44771525,16 3,16 C3.55228475,16 4,16.4477153 4,17 L4,19 C4,19.5522847 4.44771525,20 5,20 L19,20 C19.5522847,20 20,19.5522847 20,19 L20,17 C20,16.4477153 20.4477153,16 21,16 Z\"\/><path fill=\"var(--pf-icon-color)\" d=\"M12,2 C12.5522847,2 13,2.44771525 13,3 L13,14.585 L17.2928932,10.2928932 C17.6533772,9.93240926 18.2206082,9.90467972 18.6128994,10.2097046 L18.7071068,10.2928932 C19.0976311,10.6834175 19.0976311,11.3165825 18.7071068,11.7071068 L12.7071068,17.7071068 C12.3165825,18.0976311 11.6834175,18.0976311 11.2928932,17.7071068 L5.29289322,11.7071068 C4.90236893,11.3165825 4.90236893,10.6834175 5.29289322,10.2928932 C5.68341751,9.90236893 6.31658249,9.90236893 6.70710678,10.2928932 L11,14.585 L11,3 C11,2.44771525 11.4477153,2 12,2 Z\"\/><\/g><\/svg><\/span><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-21d7099 elementor-widget elementor-widget-heading\" data-id=\"21d7099\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Toplu SQL \u0130\u015flemleri<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a2135f elementor-widget elementor-widget-text-editor\" data-id=\"3a2135f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Y\u00fcksek say\u0131da sat\u0131r i\u00e7eren devasa sonu\u00e7 k\u00fcmelerini getiren SQL sorgular\u0131 m\u00fcmk\u00fcn olan en performansl\u0131 \u015fekilde \u00e7al\u0131\u015famayabilirler. Bunun sebebi, veritaban\u0131 motoru ile prosed\u00fcrel dil kodu aras\u0131nda bu <span style=\"color: #ff6600;\">sonu\u00e7 k\u00fcmelerinin transferi s\u0131ras\u0131nda s\u00fcrekli olu\u015fan ba\u011flam (context) de\u011fi\u015fimleridir.<\/span><\/p><p>Bu verimsizlik, sonu\u00e7 k\u00fcmelerinin belle\u011fe aktar\u0131m\u0131 ve istemcinin sonras\u0131nda eri\u015fimi sa\u011flanarak hafifletilebilir. Postgres Advanced Server\u2019\u0131n <span style=\"color: #ff6600;\">SPL<\/span> olarak adland\u0131rd\u0131\u011f\u0131m\u0131z sakl\u0131 yordam dili (stored procedure language), <span style=\"color: #ff6600;\">BULK COLLECT<\/span> \u00f6zelli\u011fi sayesinde <span style=\"color: #ff6600;\">b\u00fcy\u00fck sonu\u00e7 k\u00fcmelerinin bellek i\u00e7i bir koleksiyonda toplanmas\u0131n\u0131 sa\u011flar.<\/span><\/p><p>Bu t\u00fcr b\u00fcy\u00fck imle\u00e7leri i\u015fleyen PL\/pgSQL fonksiyonlar\u0131n\u0131n BULK COLLECT kullanan SPL fonksiyonlar\u0131na \u00e7evrilmesiyle <span style=\"color: #ff6600;\">performans 100% ve \u00fczerinde artt\u0131r\u0131labilir.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-21de327\" data-id=\"21de327\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-faecb7c elementor-widget elementor-widget-heading\" data-id=\"faecb7c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Dizin Dan\u0131\u015fman\u0131<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b5af44d elementor-widget elementor-widget-text-editor\" data-id=\"b5af44d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Postgres Advanced Server i\u00e7erisinde gelen bir ba\u015fka performans analiz arac\u0131\u00a0<span style=\"color: #ff6600;\"><strong>Index Advisor<\/strong><\/span>\u00a0<em>(Dizin Dan\u0131\u015fman\u0131)<\/em>\u2019d\u0131r.<\/p><p>Index Advisor, veritaban\u0131 uzmanlar\u0131na ve yaz\u0131l\u0131m geli\u015ftiricilerine, <span style=\"color: #ff6600;\">bir veya birden fazla SQL ifadesini analiz ederek<\/span> daha <span style=\"color: #ff6600;\">performansl\u0131<\/span> veri tarama i\u00e7in olu\u015fturulmas\u0131 gereken <span style=\"color: #ff6600;\">yeni dizinler (index) ile ilgili tavsiyelerde<\/span> bulunur. Bunu birden fazla s\u00fctunu i\u00e7eren <span style=\"color: #ff6600;\">bile\u015fik dizinler<\/span> i\u00e7in de yapabilmektedir.<\/p><p>Index Advisor, t\u00fcm veri de\u011fi\u015ftirme (INSERT, UPDATE, DELETE) ve SELECT ifadelerinde devreye girer.<\/p><p>Index Advisor tan\u0131 raporunda \u015fu bilgilere de yer verir:<\/p><ul><li>Yeni olu\u015fturulacak dizinler sayesinde performans art\u0131\u015flar\u0131<\/li><li>Yeni dizinlerin boyutu<\/li><li>Yeni dizinlerin olu\u015fturulmas\u0131nda kullan\u0131lacak tan\u0131mlama bilgisi (DDL)<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-837dc99 elementor-widget elementor-widget-pix-button\" data-id=\"837dc99\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"d-block w-100 text-center\"><span  class=\"btn m-0      btn-primary btn-flat d-inline-flex align-items-center pix-hover-item       animate-in pix-popup-link pix-btn-div btn-lg\"   data-anim-type=\"fade-in-up\" data-anim-delay=\"500\" data-popup-id=\"16768\"><span class=\"font-weight-bold \" >\u0130htiya\u00e7lar\u0131n\u0131z\u0131 g\u00f6r\u00fc\u015felim<\/span><svg class=\"pixfort-icon font-weight-bold  pix-hover-right  ml-2\" width=\"24\" height=\"24\"  data-name=\"Line\/pixfort-icon-arrow-right-circle-1\" viewBox=\"2 2 20 20\"><path fill=\"none\" stroke=\"var(--pf-icon-color)\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"var(--pf-icon-stroke-width)\" d=\"M12,21 C16.9705627,21 21,16.9705627 21,12 C21,7.02943725 16.9705627,3 12,3 C7.02943725,3 3,7.02943725 3,12 C3,16.9705627 7.02943725,21 12,21 Z M7,12 L16,12 M12,17 L17,12 L12,7\"\/><\/svg><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5e59531 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5e59531\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f7a3642\" data-id=\"f7a3642\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-d8bb56e shadow-sm bg-white fly-sm rounded-xl sticky-top pix-sticky-top-adjust position-sticky animated-fast elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d8bb56e\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;animation&quot;:&quot;none&quot;,&quot;animation_delay&quot;:200,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-145a347\" data-id=\"145a347\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c2731e1 elementor-invisible elementor-widget elementor-widget-pix-badge\" data-id=\"c2731e1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-badge.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"pix-element-div w-100 text-center\"><span class=\"pix-badge-element h6 d-inline-flex mr-1 animate-in\" data-anim-type=\"fade-in-up\" data-anim-delay=\"0\"><span class=\"badge font-weight-bold secondary-font  bg-red  \" style=\" \"><span class=\"text-white\" style=\"\">PAS Performans<\/span><\/span><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9eb3ba9 elementor-widget elementor-widget-pix-icon\" data-id=\"9eb3ba9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"duo-icon-71270562\" class=\"pix-icon text-left \"><div class=\"pix-icon-bg rounded-circle feature_img position-relative d-inline-flex align-items-center justify-content-center bg-red \"   style=\" width:64px;height:64px;position:relative;line-height:64px;text-align:center;\"><span style=\"font-size:36px;line-height:36px;\" class=\"text-white d-inline-flex align-middle\"><svg class=\"pixfort-icon \" width=\"36\" height=\"36\"  data-name=\"Duotone\/pixfort-icon-code-1\" viewBox=\"2 2 20 20\"><g fill=\"none\" fill-rule=\"evenodd\"><path fill=\"var(--pf-icon-color)\" fill-opacity=\".25\" d=\"M12.5769751,5.52565835 C12.8389467,4.73974337 13.6884267,4.31500339 14.4743416,4.57697505 C15.2602566,4.83894671 15.6849966,5.68842667 15.4230249,6.47434165 L11.4230249,18.4743416 C11.1610533,19.2602566 10.3115733,19.6849966 9.52565835,19.4230249 C8.73974337,19.1610533 8.31500339,18.3115733 8.57697505,17.5256584 L12.5769751,5.52565835 Z\"\/><path fill=\"var(--pf-icon-color)\" d=\"M5.43933983,6.93933983 C6.02512627,6.35355339 6.97487373,6.35355339 7.56066017,6.93933983 C8.14644661,7.52512627 8.14644661,8.47487373 7.56066017,9.06066017 L4.621,12 L7.56066017,14.9393398 C8.10983496,15.4885146 8.14415838,16.357577 7.66363044,16.9467378 L7.56066017,17.0606602 C6.97487373,17.6464466 6.02512627,17.6464466 5.43933983,17.0606602 L1.43933983,13.0606602 C0.853553391,12.4748737 0.853553391,11.5251263 1.43933983,10.9393398 L5.43933983,6.93933983 Z M18.5606602,6.93933983 C17.9748737,6.35355339 17.0251263,6.35355339 16.4393398,6.93933983 C15.8535534,7.52512627 15.8535534,8.47487373 16.4393398,9.06066017 L19.379,12 L16.4393398,14.9393398 C15.890165,15.4885146 15.8558416,16.357577 16.3363696,16.9467378 L16.4393398,17.0606602 C17.0251263,17.6464466 17.9748737,17.6464466 18.5606602,17.0606602 L22.5606602,13.0606602 C23.1464466,12.4748737 23.1464466,11.5251263 22.5606602,10.9393398 L18.5606602,6.93933983 Z\"\/><\/g><\/svg><\/span><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e296e4 elementor-widget elementor-widget-heading\" data-id=\"7e296e4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Kod Profilcisi<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-285d779 elementor-widget elementor-widget-text-editor\" data-id=\"285d779\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Kod profili \u00e7\u0131kartma i\u015flemi bir veya daha fazla prosed\u00fcrel veritaban\u0131 kod par\u00e7as\u0131n\u0131n \u00e7al\u0131\u015ft\u0131r\u0131larak <span style=\"color: #ff6600;\">performans k\u0131yaslamas\u0131n\u0131n yap\u0131lmas\u0131<\/span> ve i\u015fletim esnas\u0131nda <span style=\"color: #ff6600;\">nerede, ne kadar zaman harcand\u0131\u011f\u0131n\u0131n<\/span> \u00e7\u00f6z\u00fcmlenmesidir.<\/p><p>Profilleme ile genellikle \u015fu sorular\u0131n cevaplar\u0131 aran\u0131r:<\/p><ul><li>\u0130\u015fletim s\u00fcresinin b\u00fcy\u00fck k\u0131sm\u0131 hangi kod par\u00e7as\u0131 taraf\u0131ndan i\u015fgal ediliyor?<\/li><li>Bir d\u00f6ng\u00fc ka\u00e7 kere i\u015fletilmekte?<\/li><li>Hangi kodlama yakla\u015f\u0131m\u0131 istenen sonucu vermekte daha performansl\u0131?<\/li><\/ul><div class=\"fusion-text fusion-text-18\"><p>Profilleme yapmadan, yukar\u0131daki gibi sorular\u0131n cevaplar\u0131 sadece tahmine dayal\u0131 olur. Veritaban\u0131 ve yaz\u0131l\u0131m uzmanlar\u0131 ellerinde g\u00fc\u00e7l\u00fc ara\u00e7lar yoksa, genellikle kod par\u00e7alar\u0131n\u0131n aralar\u0131na baz\u0131 ifadeler yerle\u015ftirmek, cevap s\u00fcresini yazd\u0131rmak gibi ilkel profilleme teknikleri kullan\u0131rlar. Bunlara ilkel dememizin sebebi bu \u015fekilde bir \u00e7al\u0131\u015fma zahmetli ve zaman al\u0131c\u0131 oldu\u011fu kadar, hataya da a\u00e7\u0131kt\u0131r. \u00c7o\u011funlukla bir ava benzer, oltay\u0131 atar ve beklersiniz, bal\u0131k yoksa ba\u015fka bir yere olta atman\u0131z gerekir. <span style=\"color: #ff6600;\">Code Profiler ile bu s\u0131k\u0131nt\u0131lar\u0131 ya\u015famazs\u0131n\u0131z.<\/span><\/p><p>\u00d6zellikle <span style=\"color: #ff6600;\">Oracle DBMS_PROFILER<\/span> kullan\u0131c\u0131lar\u0131 <span style=\"color: #ff6600;\">Code Profiler<\/span> kullan\u0131rken kendilerini \u00e7ok rahat hissedecekler.<\/p><p>Bir veya daha fazla sakl\u0131 yordam\u0131 veya fonksiyonu profillemek i\u00e7in veritaban\u0131 veya yaz\u0131l\u0131m uzman\u0131n\u0131n yapmas\u0131 gerekenler k\u0131saca:<\/p><\/div><ul class=\"fusion-checklist fusion-checklist-4\"><li class=\"fusion-li-item\">Profiler\u2019\u0131 \u00e7al\u0131\u015ft\u0131r\u0131p bir oturum ad\u0131 vermek:<br \/>\u00a0 \u00a0 \u00a0(EXEC dbms_profiler.start_profiler)<\/li><li>Profillenecek kodu \u00e7al\u0131\u015ft\u0131rmak<\/li><li>Profillemeyi durdurup istatistiksel veriyi analiz etmek:<br \/>\u00a0 \u00a0 \u00a0(EXEC dbms_profiler.stop_profiler;)<\/li><\/ul><p>Code Profiler taraf\u0131ndan \u00fcretilen tan\u0131lama raporu i\u015fletme s\u00fcreleri, <span style=\"color: #ff6600;\">I\/O bilgileri, bekleyen olaylar, i\u015fletme say\u0131lar\u0131 ve daha bir\u00e7ok yard\u0131mc\u0131 bilgiyi<\/span> i\u00e7ermektedir.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-1bc0d29\" data-id=\"1bc0d29\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-960c654 elementor-widget elementor-widget-heading\" data-id=\"960c654\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">DynaTune Dinamik Optimizasyon<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-676bad7 elementor-widget elementor-widget-text-editor\" data-id=\"676bad7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>DynaTune\u2122 sunucu donan\u0131m\u0131na ba\u011fl\u0131 olarak veritaban\u0131 i\u015f y\u00fck\u00fcn\u00fcn do\u011fru optimizasyonun sa\u011flanmas\u0131 i\u00e7in kullan\u0131l\u0131r. DBA\u2019lerin en \u00e7ok s\u0131k\u0131nt\u0131 ya\u015fad\u0131klar\u0131 konu olan <span style=\"color: #ff6600;\">performans optimizasyonunu en basite indirgeyerek<\/span> size yard\u0131mc\u0131 olur.<\/p><p>Pop\u00fcler veritaban\u0131 uygulamalar\u0131 performans optimizasyonu yar\u0131\u015f\u0131nda \u201cne kadar \u00e7ok ince ayar\u0131n varsa o kadar iyisin\u201d anlay\u0131\u015f\u0131 ile hareket etmekte ve her sistem de\u011fi\u015fkenini bir ayar d\u00fc\u011fmesi haline getirmektedirler. Buna kar\u015f\u0131n bir DBA olarak bunca ince ayar\u0131n tamam\u0131n\u0131 bilmek, hangi durumlarda kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek ve en \u00f6nemlisi, her ince ayar\u0131n etkisini \u00f6l\u00e7mek sa\u00e7 ba\u015f yoldurabilecek bir hal alabilmektedir. Bu sebeple bir \u00e7ok veritaban\u0131 i\u015f y\u00fck\u00fc do\u011fru optimize edilmemi\u015f \u015fekilde \u00e7al\u0131\u015fmaya devam etmektedir. Veritaban\u0131 uzmanlar\u0131, DBA e\u011fitimi veren \u00fcstadlar bilirler ki, en iyi yakla\u015f\u0131m \u00f6nce en \u00e7ok performans getirisi sa\u011flayacak temel bir ayar seti ile ba\u015flamak ve sonra gerekirse ince ayarlara ge\u00e7mektir.<\/p><p><span style=\"color: #ff6600;\">DynaTune<\/span>, Postgres veritaban\u0131 <span style=\"color: #ff6600;\">optimizasyonundaki<\/span> <span style=\"color: #ff6600;\">belirsizlikleri ortadan kald\u0131r\u0131r.<\/span><\/p><p>Geni\u015f bir donan\u0131m yelpazesi ve veri setleri \u00fczerinde yap\u0131lm\u0131\u015f bir \u00e7ok test sonucuna g\u00f6re olu\u015fturulmu\u015f sofistike, <span style=\"color: #ff6600;\">ak\u0131ll\u0131 bir algoritma sayesinde<\/span> bir\u00e7ok veritaban\u0131 optimizasyon ayar\u0131n\u0131 kullan\u0131c\u0131dan al\u0131nacak cevaba ba\u011fl\u0131 olarak iki temel set \u00fczerinde sadele\u015ftirmektedir.<\/p><p>Kurulum esnas\u0131nda sorulan birka\u00e7 soru ile beraber daha ba\u015flang\u0131\u00e7ta, ortalamadan daha iyi bir performans optimizasyonuna sahip olursunuz. Daha sonra kullan\u0131m esnas\u0131 verilerine ba\u011fl\u0131 olarak daha ince optimizasyon ayarlar\u0131 yapabilirsiniz. B\u00f6ylece k\u00fc\u00e7\u00fck performans getirisi sa\u011flayacak ince ayarlarla u\u011fra\u015farak ayarlar\u0131n i\u00e7inde bo\u011fulmay\u0131 \u00f6nleyerek, bu \u00f6nemli oldu\u011fu kadar karma\u015f\u0131k i\u015fi basite indirger.<\/p><p>DynaTune, donan\u0131m artt\u0131rd\u0131\u011f\u0131n\u0131zda veya de\u011fi\u015ftirdi\u011finizde, \u00f6rne\u011fin bellek art\u0131r\u0131m\u0131 yapt\u0131\u011f\u0131n\u0131zda,\u00a0<span style=\"color: #ff6600;\"><b>otomatik olarak<\/b><\/span>\u00a0mevcut ayarlar\u0131 yeniden kalibre eder ve veritaban\u0131 i\u015f y\u00fck\u00fcn\u00fcn \u00f6nceki ile uyumlu \u015fekilde donan\u0131m\u0131 kullanmas\u0131n\u0131 sa\u011flar.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8bde73f elementor-widget elementor-widget-pix-button\" data-id=\"8bde73f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"d-block w-100 text-center\"><span  class=\"btn m-0      btn-primary btn-flat d-inline-flex align-items-center pix-hover-item       animate-in pix-popup-link pix-btn-div btn-lg\"   data-anim-type=\"fade-in-up\" data-anim-delay=\"500\" data-popup-id=\"16768\"><span class=\"font-weight-bold \" >\u0130htiya\u00e7lar\u0131n\u0131z\u0131 g\u00f6r\u00fc\u015felim<\/span><svg class=\"pixfort-icon font-weight-bold  pix-hover-right  ml-2\" width=\"24\" height=\"24\"  data-name=\"Line\/pixfort-icon-arrow-right-circle-1\" viewBox=\"2 2 20 20\"><path fill=\"none\" stroke=\"var(--pf-icon-color)\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"var(--pf-icon-stroke-width)\" d=\"M12,21 C16.9705627,21 21,16.9705627 21,12 C21,7.02943725 16.9705627,3 12,3 C7.02943725,3 3,7.02943725 3,12 C3,16.9705627 7.02943725,21 12,21 Z M7,12 L16,12 M12,17 L17,12 L12,7\"\/><\/svg><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-225ec04 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"225ec04\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;,&quot;shape_divider_top&quot;:&quot;tilt&quot;,&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t\t\t<div class=\"elementor-shape elementor-shape-top\" aria-hidden=\"true\" data-negative=\"false\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 1000 100\" preserveAspectRatio=\"none\">\n\t<path class=\"elementor-shape-fill\" d=\"M0,6V0h1000v100L0,6z\"\/>\n<\/svg>\t\t<\/div>\n\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-ad35572\" data-id=\"ad35572\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4097b2a elementor-widget elementor-widget-pix-photo-box\" data-id=\"4097b2a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-photo-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"card w-100 bg-heading-default bg-transparent  shadow-sm shadow-hover-sm text-left w-100 d-inline-flex pix-hover-item rounded-lg position-relative overflow-hidden text-white\" ><img decoding=\"async\" srcset=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/03\/edb-image-1-300x200.jpg 300w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/03\/edb-image-1.jpg 480w\" src=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/03\/edb-image-1.jpg\" class=\"card-img pix-bg-image h-100 pix-img-scale pix-opacity-10 rounded-lg \" alt=\"EDB Advanced Server\" title=\"\"><a href=\"\/enterprisedb-postgres-advanced-server\"  class=\"d-inline-block w-100 pix-img-overlay pix-p-10 d-flex align-items-end\" style=\"min-height:300px;\"><div class=\"w-100\"><div class=\"card-content-box pix-p-20 rounded-lg w-100 shadow  bg-dynamic-background d-flex justify-content-between align-items-center\"><div class=\"card-title font-weight-bold secondary-font text-heading-default m-0 w-100\" style=\"font-size:14px;line-height:1.28;\">EDB Advanced Server<\/div><div class=\"d-inline-flex align-middle text-heading-default\" style=\"font-size:14px;line-height:1.28;\"><svg class=\"pixfort-icon \" width=\"24\" height=\"24\"  data-name=\"Line\/pixfort-icon-arrow-right-2\" viewBox=\"2 2 20 20\"><polyline fill=\"none\" stroke=\"var(--pf-icon-color)\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"var(--pf-icon-stroke-width)\" points=\"9.5 17 14.5 12 9.5 7\"\/><\/svg><\/div><\/div><\/div><\/a><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-3cea34a\" data-id=\"3cea34a\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-03d0242 elementor-widget elementor-widget-pix-photo-box\" data-id=\"03d0242\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-photo-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"card w-100 bg-heading-default bg-transparent  shadow-sm shadow-hover-sm text-left w-100 d-inline-flex pix-hover-item rounded-lg position-relative overflow-hidden text-white\" ><img decoding=\"async\" srcset=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/gizlilik-politikamiz-300x200.png 300w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/gizlilik-politikamiz-1024x683.png 1024w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/gizlilik-politikamiz-768x512.png 768w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/gizlilik-politikamiz.png 1200w\" src=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/gizlilik-politikamiz.png\" class=\"card-img pix-bg-image h-100 pix-img-scale pix-opacity-10 rounded-lg \" alt=\"Guvenlik\" title=\"\"><a href=\"\/enterprisedb-guvenlik\"  class=\"d-inline-block w-100 pix-img-overlay pix-p-10 d-flex align-items-end\" style=\"min-height:300px;\"><div class=\"w-100\"><div class=\"card-content-box pix-p-20 rounded-lg w-100 shadow  bg-dynamic-background d-flex justify-content-between align-items-center\"><div class=\"card-title font-weight-bold secondary-font text-heading-default m-0 w-100\" style=\"font-size:14px;line-height:1.28;\">Guvenlik<\/div><div class=\"d-inline-flex align-middle text-heading-default\" style=\"font-size:14px;line-height:1.28;\"><svg class=\"pixfort-icon \" width=\"24\" height=\"24\"  data-name=\"Line\/pixfort-icon-arrow-right-2\" viewBox=\"2 2 20 20\"><polyline fill=\"none\" stroke=\"var(--pf-icon-color)\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"var(--pf-icon-stroke-width)\" points=\"9.5 17 14.5 12 9.5 7\"\/><\/svg><\/div><\/div><\/div><\/a><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-cb569e5\" data-id=\"cb569e5\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2944438 elementor-widget elementor-widget-pix-photo-box\" data-id=\"2944438\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-photo-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"card w-100 bg-heading-default bg-transparent  shadow-sm shadow-hover-sm text-left w-100 d-inline-flex pix-hover-item rounded-lg position-relative overflow-hidden text-white\" ><img decoding=\"async\" srcset=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/kalite-politikamiz-300x200.png 300w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/kalite-politikamiz-1024x683.png 1024w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/kalite-politikamiz-768x512.png 768w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/kalite-politikamiz.png 1200w\" src=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2022\/09\/kalite-politikamiz.png\" class=\"card-img pix-bg-image h-100 pix-img-scale pix-opacity-10 rounded-lg \" alt=\"Y\u00f6netim\" title=\"\"><a href=\"\/enterprisedb-yonetim\"  class=\"d-inline-block w-100 pix-img-overlay pix-p-10 d-flex align-items-end\" style=\"min-height:300px;\"><div class=\"w-100\"><div class=\"card-content-box pix-p-20 rounded-lg w-100 shadow  bg-dynamic-background d-flex justify-content-between align-items-center\"><div class=\"card-title font-weight-bold secondary-font text-heading-default m-0 w-100\" style=\"font-size:14px;line-height:1.28;\">Y\u00f6netim<\/div><div class=\"d-inline-flex align-middle text-heading-default\" style=\"font-size:14px;line-height:1.28;\"><svg class=\"pixfort-icon \" width=\"24\" height=\"24\"  data-name=\"Line\/pixfort-icon-arrow-right-2\" viewBox=\"2 2 20 20\"><polyline fill=\"none\" stroke=\"var(--pf-icon-color)\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"var(--pf-icon-stroke-width)\" points=\"9.5 17 14.5 12 9.5 7\"\/><\/svg><\/div><\/div><\/div><\/a><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-8ca32c9\" data-id=\"8ca32c9\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;pix_scale_in&quot;:&quot;none&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c38c65f elementor-widget elementor-widget-pix-photo-box\" data-id=\"c38c65f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"pix-photo-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"card w-100 bg-heading-default bg-transparent  shadow-sm shadow-hover-sm text-left w-100 d-inline-flex pix-hover-item rounded-lg position-relative overflow-hidden text-white\" ><img decoding=\"async\" srcset=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/06\/edb-sertifika-egitimleri-menu.webp 200w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/06\/edb-sertifika-egitimleri-menu-150x150.webp 150w, https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/06\/edb-sertifika-egitimleri-menu-75x75.webp 75w\" src=\"https:\/\/profelis.com.tr\/wp-content\/uploads\/2025\/06\/edb-sertifika-egitimleri-menu.webp\" class=\"card-img pix-bg-image h-100 pix-img-scale pix-opacity-10 rounded-lg \" alt=\"Sertifikasyon\" title=\"\"><a href=\"\/postgresql-sertifika\/\"  class=\"d-inline-block w-100 pix-img-overlay pix-p-10 d-flex align-items-end\" style=\"min-height:300px;\"><div class=\"w-100\"><div class=\"card-content-box pix-p-20 rounded-lg w-100 shadow  bg-dynamic-background d-flex justify-content-between align-items-center\"><div class=\"card-title font-weight-bold secondary-font text-heading-default m-0 w-100\" style=\"font-size:14px;line-height:1.28;\">Sertifikasyon<\/div><div class=\"d-inline-flex align-middle text-heading-default\" style=\"font-size:14px;line-height:1.28;\"><svg class=\"pixfort-icon \" width=\"24\" height=\"24\"  data-name=\"Line\/pixfort-icon-arrow-right-2\" viewBox=\"2 2 20 20\"><polyline fill=\"none\" stroke=\"var(--pf-icon-color)\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"var(--pf-icon-stroke-width)\" points=\"9.5 17 14.5 12 9.5 7\"\/><\/svg><\/div><\/div><\/div><\/a><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>EDB Postgres Advanced Server EDB&#32; Postgres&#32; Advanced&#32; Server&#32; Performans&#32; D\u00fcnyan\u0131n en geli\u015fmi\u015f a\u00e7\u0131k kaynak veritaban\u0131 Projelerinizle ilgili bize ula\u015f\u0131n Daha fazla bilgi almaya m\u0131 ihtiyac\u0131n\u0131z var? Bizimle ileti\u015fime ge\u00e7in EnterpriseDB size ve kurumunuza PostgreSQL veri tabanlar\u0131n\u0131 kullanabilmeniz, verinizi PostgreSQL\u2019e ta\u015f\u0131yabilmeniz&#8230;<\/p>","protected":false},"author":1,"featured_media":34108,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-17041","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/pages\/17041","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=17041"}],"version-history":[{"count":39,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/pages\/17041\/revisions"}],"predecessor-version":[{"id":35080,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/pages\/17041\/revisions\/35080"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media\/34108"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=17041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}