{"id":4192,"date":"2025-11-04T17:47:19","date_gmt":"2025-11-04T14:47:19","guid":{"rendered":"https:\/\/www.ozgurguler.net\/blog\/?p=4192"},"modified":"2026-05-04T10:49:26","modified_gmt":"2026-05-04T07:49:26","slug":"performans-satin-alinmaz-tasarlanir","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/performans-satin-alinmaz-tasarlanir\/","title":{"rendered":"Performans sat\u0131n al\u0131nmaz, tasarlan\u0131r."},"content":{"rendered":"
Donan\u0131m De\u011fil, Mimari Belirler \u2013 Ama Paket Yaz\u0131l\u0131mda Mimari Sizin Elinizde De\u011fil<\/strong><\/h5>\n
Performans Sat\u0131n Al\u0131nmaz, Tasarlan\u0131r<\/strong><\/h6>\n

Donan\u0131m De\u011fil, Mimari Belirler \u2013 Ama Paket Yaz\u0131l\u0131mda Mimari Sizin Elinizde De\u011fil<\/em><\/strong><\/p>\n

Bu rehber, ERP, muhasebe, stok veya sat\u0131\u015f y\u00f6netimi gibi paket yaz\u0131l\u0131mlar\u0131 kullanan i\u015fletme sahipleri, IT y\u00f6neticileri ve dan\u0131\u015fmanlar i\u00e7in haz\u0131rlanm\u0131\u015ft\u0131r.<\/strong><\/p>\n

Ama\u00e7, donan\u0131m yat\u0131r\u0131mlar\u0131n\u0131n neden s\u0131n\u0131rl\u0131 sonu\u00e7 verdi\u011fini ve ger\u00e7ek performans art\u0131\u015f\u0131 i\u00e7in nas\u0131l bir yakla\u015f\u0131m gerekti\u011fini anlatmakt\u0131r.<\/strong><\/p>\n

\u00a0<\/strong><\/p>\n

Giri\u015f: Temel Yan\u0131lg\u0131<\/strong><\/p>\n

“\u0130yi donan\u0131m, k\u00f6t\u00fc mimariyi kurtaramaz. Ama iyi mimari, orta d\u00fczey donan\u0131mla harikalar yarat\u0131r.” Bu kural, \u00f6zellikle ERP, muhasebe ve depo yaz\u0131l\u0131mlar\u0131 gibi paket sistemler i\u00e7in ge\u00e7erlidir. Bir\u00e7ok kullan\u0131c\u0131, yava\u015f \u00e7al\u0131\u015fan raporlar\u0131n \u00e7\u00f6z\u00fcm\u00fcn\u00fc daha h\u0131zl\u0131 sunucular, daha fazla RAM veya daha iyi i\u015flemcilerde arar. Ancak ac\u0131 ger\u00e7ek \u015fudur:\u00a0Ne kadar g\u00fc\u00e7l\u00fc donan\u0131m koyarsan\u0131z koyun, paket yaz\u0131l\u0131mlarda rapor h\u0131z\u0131 belirli bir seviyenin \u00fcst\u00fcne \u00e7\u0131kamaz.<\/strong><\/h6>\n
Neden? \u00c7\u00fcnk\u00fc performans\u0131n %80’i veri modeli ve sorgu stratejisinden gelir. Bu strateji ise paket yaz\u0131l\u0131m\u0131n i\u00e7inde sabittir ve sizin kontrol\u00fcn\u00fczde de\u011fildir. Donan\u0131m sadece bir “ta\u015f\u0131y\u0131c\u0131d\u0131r”; mimari do\u011fru de\u011filse, en pahal\u0131 sistem bile bo\u011fulur.<\/strong><\/h6>\n
Bu noktada bir yan\u0131lg\u0131y\u0131 daha d\u00fczeltmek gerekir:
\nYava\u015f raporlar\u0131n sorumlusu ne yaz\u0131l\u0131m evi ne de destek ekibidir.
\n\u00c7\u00fcnk\u00fc performans\u0131n as\u0131l belirleyicisi olan veri modeli, indeksleme yap\u0131s\u0131 ve sorgu mimarisi yaz\u0131l\u0131m\u0131n \u00e7ekirde\u011finde yer al\u0131r ve kullan\u0131c\u0131 ya da destek personeli taraf\u0131ndan de\u011fi\u015ftirilemez.
\nDolay\u0131s\u0131yla, performans s\u0131n\u0131r\u0131na ula\u015f\u0131ld\u0131\u011f\u0131nda su\u00e7lanacak bir taraf de\u011fil, do\u011fal bir mimari limit vard\u0131r.<\/strong><\/h5>\n

\u00a01- <\/strong>Donan\u0131m \u0130yile\u015ftirir, Ama D\u00f6n\u00fc\u015ft\u00fcrmez<\/strong><\/p>\n

Paket yaz\u0131l\u0131mlarda donan\u0131m y\u00fckseltmek, performans\u0131 lineer olarak art\u0131rmaz. Sadece mevcut mimarinin izin verdi\u011fi \u00fcst s\u0131n\u0131ra biraz daha yakla\u015ft\u0131r\u0131r.<\/strong><\/h6>\n\n\n\n\n\n\n\n
\n
Donan\u0131m Seviyesi<\/strong><\/h6>\n<\/td>\n
\n
Tipik 10 Y\u0131ll\u0131k Veride Rapor S\u00fcresi<\/strong><\/h6>\n<\/td>\n<\/tr>\n<\/thead>\n
\n
Orta seviye sunucu<\/strong><\/h6>\n<\/td>\n
\n
5 \u2013 15 dakika<\/strong><\/h6>\n<\/td>\n<\/tr>\n
\n
En \u00fcst seviye sunucu<\/strong><\/h6>\n<\/td>\n
\n
1 \u2013 5 dakika<\/strong><\/h6>\n<\/td>\n<\/tr>\n
\n
1 Saniye?<\/strong><\/h6>\n<\/td>\n
\n
Paket yaz\u0131l\u0131m mimarisi ile m\u00fcmk\u00fcn de\u011fil<\/strong><\/h6>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
E\u011fer sorgunuz her seferinde 10 y\u0131ll\u0131k ham veriyi tar\u0131yorsa, 500 GB\/s disk h\u0131z\u0131, 1000 \u00e7ekirdek ve 2 TB RAM bile 1 saniyelik cevap i\u00e7in yetersiz kalacakt\u0131r. \u00c7\u00fcnk\u00fc darbo\u011faz, donan\u0131mda de\u011fil,\u00a0I\/O, indeksleme ve sorgu planlama\u00a0seviyesindedir.<\/strong><\/h6>\n
    \n
  1. Paket Yaz\u0131l\u0131mlar\u0131n Do\u011fas\u0131: Neleri Sunar, Neleri Sunmaz?<\/strong><\/li>\n<\/ol>\n
    Paket yaz\u0131l\u0131mlar, ad\u0131 \u00fcst\u00fcnde, genel ihtiya\u00e7lara hitap etmek i\u00e7in tasarlanm\u0131\u015ft\u0131r. G\u00fc\u00e7l\u00fc olduklar\u0131 ve zay\u0131f kald\u0131klar\u0131 alanlar nettir:<\/strong><\/h6>\n\n\n\n\n\n\n\n\n\n
    \n
    \u00d6zellik<\/strong><\/h6>\n<\/td>\n
    		\n
    Paket Yaz\u0131l\u0131mda Durum<\/strong><\/h6>\n<\/td>\n<\/tr>\n<\/thead>\n
    \n
    G\u00fcnl\u00fck fi\u015f\/giri\u015f-\u00e7\u0131k\u0131\u015f i\u015flemleri<\/strong><\/h6>\n<\/td>\n
    		\n
    \u2705\u00a0M\u00fckemmel\u00a0(OLTP i\u00e7in optimize)<\/strong><\/h6>\n<\/td>\n<\/tr>\n
    \n
    Standart, \u00f6nceden tan\u0131mlanm\u0131\u015f raporlar<\/strong><\/h6>\n<\/td>\n
    		\n
    \u2705\u00a0Sorunsuz<\/strong><\/h6>\n<\/td>\n<\/tr>\n
    \n
    10 y\u0131ll\u0131k veride anl\u0131k, \u00f6zg\u00fcr analiz<\/strong><\/h6>\n<\/td>\n
    		\n
    \u274c\u00a0Mimari izin vermez<\/strong><\/h6>\n<\/td>\n<\/tr>\n
    \n
    \u00d6zet tablo \/ \u00f6nbellek katman\u0131<\/strong><\/h6>\n<\/td>\n
    		\n
    \u274c\u00a0Genelde yoktur<\/strong><\/h6>\n<\/td>\n<\/tr>\n
    \n
    \u00d6zel sorgu optimizasyonu<\/strong><\/h6>\n<\/td>\n
    		\n
    \u274c\u00a0Sizin kontrol\u00fcn\u00fczde de\u011fil<\/strong><\/h6>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Sonu\u00e7:\u00a0Paket yaz\u0131l\u0131m, g\u00fcnl\u00fck operasyonel i\u015fler i\u00e7in tasarlanm\u0131\u015ft\u0131r. A\u011f\u0131r analitik raporlar ise farkl\u0131 bir mimari katman gerektirir.<\/strong><\/h4>\n
    \u00a0<\/strong>Bu y\u00fczden, yaz\u0131l\u0131m firmalar\u0131ndan \u201cdaha h\u0131zl\u0131 rapor\u201d beklentisi \u00e7o\u011fu zaman ger\u00e7ek\u00e7i de\u011fildir.
    \nOnlar size \u00e7\u00f6z\u00fcm \u00fcretmek ister, ancak yaz\u0131l\u0131m\u0131n mimarisi izin vermez.
    \nGer\u00e7ek \u00e7\u00f6z\u00fcm, yaz\u0131l\u0131m\u0131 de\u011fi\u015ftirmekte de\u011fil, ona destek olacak do\u011fru katman\u0131 eklemektedir.<\/strong><\/h6>\n
      \n
    1. Ger\u00e7ek \u00c7\u00f6z\u00fcm: Mimariyi De\u011fi\u015ftirmek Yerine, Katman Eklemek<\/strong><\/li>\n<\/ol>\n
      Hi\u00e7bir dan\u0131\u015fman veya IT ekibi, bir paket yaz\u0131l\u0131m\u0131n (Logo, Netsis, SAP vb.) i\u00e7 mimarisini k\u00f6kten de\u011fi\u015ftiremez. Bu, yaz\u0131l\u0131m\u0131n \u00e7ekirdek mant\u0131\u011f\u0131 ve lisanslama ile \u00e7eli\u015fen bir risktir.<\/strong><\/h6>\n
      Tek kal\u0131c\u0131 ve ger\u00e7ek\u00e7i \u00e7\u00f6z\u00fcm, sisteme d\u0131\u015far\u0131dan bir “analitik katman” eklemektir.<\/strong><\/h6>\n
      Donan\u0131m Y\u00fckseltme \u2192 %20-30 h\u0131z art\u0131\u015f\u0131<\/h6>\n
      Analitik Katman (ETL + \u00d6zet Tablolar) \u2192 %1000+ h\u0131z art\u0131\u015f\u0131<\/h6>\n
      Bu \u00e7\u00f6z\u00fcm\u00fcn temeli \u015fu \u00fc\u00e7 ad\u0131ma dayan\u0131r:<\/strong><\/h6>\n\n\n\n\n\n\n\n
      \n
      Ad\u0131m<\/strong><\/h6>\n<\/td>\n
      		\n
      A\u00e7\u0131klama<\/strong><\/h6>\n<\/td>\n<\/tr>\n<\/thead>\n
      \n
      1. Paket Yaz\u0131l\u0131m\u0131 Oldu\u011fu Gibi B\u0131rak\u0131n<\/strong><\/h6>\n<\/td>\n
      		\n
      G\u00fcnl\u00fck i\u015fler i\u00e7in zaten yeterli ve g\u00fcvenilirdir. Onun i\u015fini yapmas\u0131na izin verin.<\/strong><\/h6>\n<\/td>\n<\/tr>\n
      \n
      2. Veriyi D\u00fczenli Olarak D\u0131\u015far\u0131 \u00c7\u0131kar\u0131n<\/strong><\/h6>\n<\/td>\n
      		\n
      ETL (Extract, Transform, Load) s\u00fcre\u00e7leri ile veriyi g\u00fcnl\u00fck veya anl\u0131k olarak paket yaz\u0131l\u0131m\u0131n veritaban\u0131ndan al\u0131n.<\/strong><\/h6>\n<\/td>\n<\/tr>\n
      \n
      3. D\u0131\u015f Sistemde \u00d6zet Tablolar ve Raporlar Kurun<\/strong><\/h6>\n<\/td>\n
      		\n
      Raporlar\u0131n\u0131z\u0131, bu \u00f6zelle\u015ftirilmi\u015f d\u0131\u015f sistemden \u00e7al\u0131\u015ft\u0131r\u0131n.<\/strong><\/h6>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      \u00d6rnek Senaryo:<\/strong><\/p>\n

        \n
      • \n
        Paket Yaz\u0131l\u0131m:\u00a0Mikro, Logo, Netsis, SAP<\/strong><\/h6>\n<\/li>\n
      • \n
        D\u0131\u015f Analitik Katman:\u00a0Qlik Sense, \u00a0Power BI <\/strong><\/h6>\n<\/li>\n
      • \n
        Sonu\u00e7:\u00a05 dakika s\u00fcren bir rapor, 1 saniyenin alt\u0131na iner.<\/strong><\/h6>\n<\/li>\n<\/ul>\n
        Bu nas\u0131l m\u00fcmk\u00fcn olur?\u00a0\u0130\u015fte burada teknik mimari devreye girer:<\/strong><\/h6>\n
          \n
        • \n
          \u00d6zet Tablolar (Materialized Views):\u00a0Ham veri, periyodik olarak (dakika, saat, g\u00fcn baz\u0131nda) \u00f6nceden \u00f6zetlenir. Rapor, 500 GB’\u0131 de\u011fil, 10 MB’l\u0131k bu \u00f6zet tabloyu tarar.<\/strong><\/h6>\n<\/li>\n
        • \n
          OLAP Veritabanlar\u0131:\u00a0ClickHouse gibi columnar veritabanlar\u0131, analitik sorgular i\u00e7in inan\u0131lmaz h\u0131z sa\u011flar.<\/strong><\/h6>\n<\/li>\n
        • \n
          Bellek \u0130\u00e7i \u00d6nbellek:\u00a0S\u0131k sorgulanan metrikler Redis gibi sistemlerde tutulur.<\/strong><\/h6>\n<\/li>\n<\/ul>\n

          \u00a04- <\/strong>Yat\u0131r\u0131m\u0131n\u0131z\u0131 Do\u011fru Yere Yap\u0131n: Donan\u0131m m\u0131, Mimari mi?<\/strong><\/p>\n

          K\u0131s\u0131tl\u0131 b\u00fct\u00e7enizi nereye harcayaca\u011f\u0131n\u0131z\u0131 belirlerken a\u015fa\u011f\u0131daki kar\u015f\u0131la\u015ft\u0131rma size yol g\u00f6sterebilir:<\/strong><\/h6>\n\n\n\n\n\n\n
          \n
          Yat\u0131r\u0131m T\u00fcr\u00fc<\/strong><\/h6>\n<\/td>\n
          		\n
          Beklenen Sonu\u00e7 (\u00d6rnek)<\/strong><\/h6>\n<\/td>\n
          		\n
          Etkisi<\/strong><\/h6>\n<\/td>\n<\/tr>\n<\/thead>\n
          \n
          Donan\u0131m (Daha \u0130yi Sunucu, RAM, SSD)<\/strong><\/h6>\n<\/td>\n
          		\n
          Rapor 5 dk \u2192 1 dk<\/strong><\/h6>\n<\/td>\n
          		\n
          K\u0131sa vadeli, s\u0131n\u0131rl\u0131 bir rahatlama.\u00a0Mevcut sistemin potansiyelini sonuna kadar zorlars\u0131n\u0131z.<\/strong><\/h6>\n<\/td>\n<\/tr>\n
          \n
          D\u0131\u015f Raporlama Sistemi + ETL S\u00fcreci<\/strong><\/h6>\n<\/td>\n
          		\n
          Rapor 5 dk \u2192 1 sn<\/strong><\/h6>\n<\/td>\n
          		\n
          Kal\u0131c\u0131 ve d\u00f6n\u00fc\u015ft\u00fcr\u00fcc\u00fc bir \u00e7\u00f6z\u00fcm.\u00a0Analitik kabiliyetleriniz katlanarak artar.<\/strong><\/h6>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          Donan\u0131m = K\u0131sa vadeli rahatlama. D\u0131\u015f Katman = Uzun vadeli \u00e7\u00f6z\u00fcm.<\/strong><\/p>\n

          \u00a0<\/strong>\ud83e\udde9 Son S\u00f6z<\/strong><\/p>\n

          Paket yaz\u0131l\u0131mlar k\u00f6t\u00fc de<\/strong>\u011f<\/strong>ildir; sadece ama\u00e7lar\u0131 ve s\u0131n\u0131rlar\u0131 bellidir.
          \nOnlar, g\u00fcnl\u00fck operasyonlar\u0131n\u0131z i\u00e7in g\u00fcvenilir i<\/strong>\u015f<\/strong> ortaklar\u0131d\u0131r.
          \nAma anl\u0131k analiz, stratejik karar ve ileri seviye raporlama i\u00e7in farkl\u0131 bir mimari gerekir.<\/strong><\/p>\n

          \ud83d\udcac Bir Ger\u00e7ek Daha: Su\u00e7lu Yok, S\u0131n\u0131r Var<\/strong><\/p>\n

          Bu tablo kimsenin hatas\u0131 de<\/strong>\u011f<\/strong>ildir.
          \nPaket yaz\u0131l\u0131m evleri ve destek ekipleri, kendi sistemlerinin s\u0131n\u0131rlar\u0131 i\u00e7inde en iyi hizmeti sunmaya \u00e7al\u0131<\/strong>\u015f<\/strong>\u0131rlar.
          \nAncak bir yaz\u0131l\u0131m, mimarisinin izin verdi<\/strong>\u011f<\/strong>i kadar h\u0131zl\u0131 olabilir.
          \nPerformans sorunlar\u0131n\u0131 ki<\/strong>\u015f<\/strong>ilere veya firmalara y\u00fcklemek yerine, sistemin do<\/strong>\u011f<\/strong>as\u0131n\u0131 anlamak gerekir.
          \nSorun de<\/strong>\u011f<\/strong>il, do<\/strong>\u011f<\/strong>al bir s\u0131n\u0131r vard\u0131r.
          \n\u00c7\u00f6z\u00fcm ise o s\u0131n\u0131r\u0131n d\u0131<\/strong>\u015f<\/strong>\u0131na \u00e7\u0131kacak yeni bir katman tasarlamakt\u0131r.<\/strong><\/h6>\n

          \ud83d\udca1 Unutmay\u0131n:
          \n\u201c<\/strong>\u0130<\/strong>yi donan\u0131m, k\u00f6t\u00fc mimariyi kurtaramaz.
          \nAma iyi mimari, orta d\u00fczey donan\u0131m\u0131 u\u00e7urur.\u201d<\/strong><\/p>\n

          Kaynaklar\u0131n\u0131z\u0131 paket yaz\u0131l\u0131m\u0131 zorlamak yerine, onunla uyumlu \u00e7al\u0131<\/strong>\u015f<\/strong>an analitik bir katmana ay\u0131r\u0131n.
          \nO zaman hem sistemlerinizin dengesi bozulmaz, hem de saniyeler i\u00e7inde yan\u0131t veren raporlara sahip olursunuz.<\/strong><\/h6>\n
          Yazan:<\/strong> \u00d6zg\u00fcr G\u00dcLER \u2013 White Eagles<\/em><\/h6>\n
          Business Development Manager \/ Software Developer Manager<\/strong>
          <\/h6>\n

          \u00a0<\/strong><\/p>\n

          \u00a0<\/strong><\/p>\n

          \u00a0<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

          Donan\u0131m De\u011fil, Mimari Belirler \u2013 Ama Paket Yaz\u0131l\u0131mda Mimari Sizin Elinizde De\u011fil Performans Sat\u0131n Al\u0131nmaz, Tasarlan\u0131r Donan\u0131m De\u011fil, Mimari Belirler \u2013 Ama Paket Yaz\u0131l\u0131mda Mimari Sizin Elinizde De\u011fil Bu rehber, ERP, muhasebe, stok veya sat\u0131\u015f y\u00f6netimi gibi paket yaz\u0131l\u0131mlar\u0131 kullanan i\u015fletme sahipleri, IT y\u00f6neticileri ve dan\u0131\u015fmanlar i\u00e7in haz\u0131rlanm\u0131\u015ft\u0131r. Ama\u00e7, donan\u0131m yat\u0131r\u0131mlar\u0131n\u0131n neden s\u0131n\u0131rl\u0131 sonu\u00e7 verdi\u011fini […]<\/p>\n","protected":false},"author":4,"featured_media":4105,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,9,243,15],"tags":[],"class_list":["post-4192","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lbs","category-mikro-yazilimevi","category-one-cikan","category-teknoloji-haberleri"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=4192"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4192\/revisions"}],"predecessor-version":[{"id":4194,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/4192\/revisions\/4194"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/4105"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=4192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=4192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=4192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}