{"id":53,"date":"2026-10-14T17:18:00","date_gmt":"2026-10-14T17:18:00","guid":{"rendered":"https:\/\/www.akifsen.com.tr\/blog\/2026\/10\/14\/orm-n-plus-one-query\/"},"modified":"2026-10-14T17:18:00","modified_gmt":"2026-10-14T17:18:00","slug":"orm-n-plus-one-query","status":"publish","type":"post","link":"https:\/\/www.akifsen.com.tr\/blog\/2026\/10\/14\/orm-n-plus-one-query\/","title":{"rendered":"ORM Kullanmak SQL Bilmemeyi Affetmez: N+1 Problemi"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u015eu kod incelemede muhtemelen hi\u00e7 dikkat \u00e7ekmez:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>List&lt;Order&gt; orders = orderRepository.findRecent();\n\nreturn orders.stream()\n    .map(o -&gt; new OrderDto(\n        o.getId(),\n        o.getCustomer().getName(),\n        o.getTotal()))\n    .toList();<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Okunakl\u0131. K\u0131sa. Do\u011fru sonu\u00e7 d\u00f6nd\u00fcr\u00fcyor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ama arka planda \u015funlar oluyor:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM orders ORDER BY created_at DESC LIMIT 200;\nSELECT * FROM customers WHERE id = ?;\nSELECT * FROM customers WHERE id = ?;\n...<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bir sorgu sipari\u015fleri getiriyor. Sonra her sipari\u015f i\u00e7in m\u00fc\u015fteriyi getiren ayr\u0131 bir sorgu \u00e7al\u0131\u015f\u0131yor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">200 sipari\u015f i\u00e7in 201 sorgu.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Neden fark edilmiyor?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Geli\u015ftirici ortam\u0131nda veritaban\u0131 ayn\u0131 makinede \u00e7al\u0131\u015f\u0131r. Her sorgu 0.3 ms s\u00fcrer. 201 sorgu 60 ms eder.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kimse \u015fikayet etmez.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Production&#8217;da veritaban\u0131 ayr\u0131 bir makinededir. Her sorgunun network round-trip maliyeti 1-2 ms olur. Ayn\u0131 endpoint art\u0131k 400 ms s\u00fcrer. Trafik artt\u0131\u011f\u0131nda connection pool bu sorgularla dolar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00dcstelik kod taraf\u0131nda hi\u00e7bir \u015fey de\u011fi\u015fmemi\u015ftir. Problem verinin b\u00fcy\u00fcmesiyle kendili\u011finden ortaya \u00e7\u0131kar.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Lazy loading<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Problemin kayna\u011f\u0131 lazy loading&#8217;dir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>@ManyToOne<\/code> ili\u015fkisi lazy tan\u0131mland\u0131\u011f\u0131nda Hibernate m\u00fc\u015fteri nesnesinin yerine bir proxy koyar. <code>getCustomer().getName()<\/code> \u00e7a\u011fr\u0131ld\u0131\u011f\u0131 anda proxy veritaban\u0131na gider.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu davran\u0131\u015f kendi ba\u015f\u0131na k\u00f6t\u00fc de\u011fil. \u0130li\u015fkili veri her zaman gerekmiyorsa y\u00fcklenmemesi mant\u0131kl\u0131.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sorun, verinin bir d\u00f6ng\u00fc i\u00e7inde tek tek istenmesidir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu arada JPA&#8217;da <code>@ManyToOne<\/code> ili\u015fkisinin varsay\u0131lan\u0131 eager&#8217;d\u0131r. Eager loading N+1&#8217;i \u00e7\u00f6zmez, sadece her yere ta\u015f\u0131r. Bu y\u00fczden genel tavsiye ili\u015fkileri lazy tan\u0131mlamak ve ihtiya\u00e7 olan yerde a\u00e7\u0131k\u00e7a y\u00fcklemektir.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Fetch join<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0130htiya\u00e7 belliyse veri tek sorguda istenebilir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@Query(\"\"\"\n    select o from Order o\n    join fetch o.customer\n    order by o.createdAt desc\n    \"\"\")\nList&lt;Order&gt; findRecentWithCustomer(Pageable page);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">201 sorgu yerine tek bir join.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ayn\u0131 sonucu <code>@EntityGraph<\/code> ile de almak m\u00fcmk\u00fcn:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@EntityGraph(attributePaths = \"customer\")\nList&lt;Order&gt; findTop200ByOrderByCreatedAtDesc();<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Collection fetch ve pagination<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Fetch join&#8217;in bir tuza\u011f\u0131 var.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>@OneToMany<\/code> bir collection&#8217;\u0131 fetch join ile y\u00fckleyip ayn\u0131 anda pagination yapmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda Hibernate \u015fu uyar\u0131y\u0131 verir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>HHH90003004: firstResult\/maxResults specified\nwith collection fetch; applying in memory<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Yani sorgu t\u00fcm sonu\u00e7lar\u0131 belle\u011fe \u00e7eker ve sayfalamay\u0131 uygulama i\u00e7inde yapar. K\u00fc\u00e7\u00fck tabloda fark edilmez, b\u00fcy\u00fck tabloda <code>OutOfMemoryError<\/code> getirebilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu durumda iki a\u015famal\u0131 yakla\u015f\u0131m daha g\u00fcvenlidir: \u00f6nce sayfalanm\u0131\u015f ID&#8217;leri getir, sonra o ID&#8217;ler i\u00e7in ili\u015fkileri y\u00fckle. Hibernate&#8217;in <code>@BatchSize<\/code> anotasyonu da lazy collection&#8217;lar\u0131 tek tek de\u011fil, gruplar halinde y\u00fckleyerek sorgu say\u0131s\u0131n\u0131 ciddi \u015fekilde azalt\u0131r.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">DTO projection<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bazen entity y\u00fcklemeye hi\u00e7 gerek yoktur.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sadece sipari\u015f ID&#8217;si, m\u00fc\u015fteri ad\u0131 ve toplam tutar g\u00f6sterilecekse:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select new com.example.OrderSummary(\n    o.id, c.name, o.total)\nfrom Order o join o.customer c<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Sadece gereken kolonlar okunur. Persistence context&#8217;e entity eklenmez. Dirty checking maliyeti olu\u015fmaz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Okuma a\u011f\u0131rl\u0131kl\u0131 endpoint&#8217;lerde, \u00f6zellikle listelerde, projection genellikle en verimli se\u00e7enektir.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tespit etmek<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">N+1&#8217;i code review ile yakalamak zordur. \u00d6l\u00e7mek gerekir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Geli\u015ftirme ortam\u0131nda SQL loglar\u0131n\u0131 a\u00e7mak ilk ad\u0131md\u0131r. Ama as\u0131l etkili y\u00f6ntem test i\u00e7inde sorgu say\u0131s\u0131n\u0131 do\u011frulamakt\u0131r. Hibernate statistics veya datasource-proxy gibi bir ara\u00e7la \u015f\u00f6yle bir assertion yaz\u0131labilir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>assertThat(queryCount).isLessThanOrEqualTo(2);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Biri ileride DTO&#8217;ya yeni bir lazy alan ekledi\u011finde test k\u0131r\u0131l\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ORM&#8217;ler veritaban\u0131 eri\u015fimini kolayla\u015ft\u0131r\u0131yor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ama veritaban\u0131na ka\u00e7 kez gitti\u011fimizi gizlemeleri, en pahal\u0131 hatalar\u0131m\u0131z\u0131n baz\u0131lar\u0131n\u0131 da g\u00f6r\u00fcnmez yap\u0131yor.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tek bir endpoint 201 sorgu \u00e7al\u0131\u015ft\u0131r\u0131yor ve kimse fark etmiyor. ORM&#8217;lerde N+1 problemi nas\u0131l olu\u015fur, nas\u0131l yakalan\u0131r ve fetch join ile nas\u0131l \u00e7\u00f6z\u00fcl\u00fcr?<\/p>\n","protected":false},"author":1,"featured_media":52,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-53","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-veritabani"],"_links":{"self":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/posts\/53","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=53"}],"version-history":[{"count":0,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/posts\/53\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/media\/52"}],"wp:attachment":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=53"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=53"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}