{"id":1949,"date":"2013-07-20T09:31:09","date_gmt":"2013-07-20T07:31:09","guid":{"rendered":"http:\/\/www.tutego.de\/blog\/javainsel\/?p=1949"},"modified":"2013-07-20T09:39:43","modified_gmt":"2013-07-20T07:39:43","slug":"thema-der-woche-n1-select-problem-2","status":"publish","type":"post","link":"https:\/\/www.tutego.de\/blog\/javainsel\/2013\/07\/thema-der-woche-n1-select-problem-2\/","title":{"rendered":"Thema der Woche: N+1 SELECT Problem"},"content":{"rendered":"<p>Bei SQL-Anfragen \u00fcber mehrere Tabellen trifft man schnell \u00fcber das N+1 SELECT Problem.<\/p>\n<ul>\n<li>Finde mehr zu dem Problem und entwerfe ein Szenario, was das Problem deutlich macht. <\/li>\n<li>Welche L\u00f6sung gibt es f\u00fcr das Problem in SQL? <\/li>\n<li>Wie l\u00f6st man das Problem in einer Anfragesprache wie JPAQL? <\/li>\n<li>L\u00e4sst sich das Problem durch geschickte Modellierung entsch\u00e4rfen? Warum ist das insbesondere f\u00fcr NoSQL-Datenbanken essenziell? Welchen Ansatz verfolgt man?<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Bei SQL-Anfragen \u00fcber mehrere Tabellen trifft man schnell \u00fcber das N+1 SELECT Problem. Finde mehr zu dem Problem und entwerfe ein Szenario, was das Problem deutlich macht. Welche L\u00f6sung gibt es f\u00fcr das Problem in SQL? Wie l\u00f6st man das Problem in einer Anfragesprache wie JPAQL? L\u00e4sst sich das Problem durch geschickte Modellierung entsch\u00e4rfen? Warum [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[13],"tags":[],"class_list":["post-1949","post","type-post","status-publish","format-standard","hentry","category-die-wochentliche-dosis-java"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/comments?post=1949"}],"version-history":[{"count":1,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1949\/revisions"}],"predecessor-version":[{"id":1950,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/posts\/1949\/revisions\/1950"}],"wp:attachment":[{"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/media?parent=1949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/categories?post=1949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tutego.de\/blog\/javainsel\/wp-json\/wp\/v2\/tags?post=1949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}