{"id":7802,"date":"2018-04-05T00:00:00","date_gmt":"2018-04-04T22:00:00","guid":{"rendered":"https:\/\/blog.ouidou.fr\/?p=7802"},"modified":"2024-08-22T11:37:59","modified_gmt":"2024-08-22T09:37:59","slug":"chasser-les-requetes-n1-avec-bullet","status":"publish","type":"post","link":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet","title":{"rendered":"Chasser les requ\u00eates N+1 avec Bullet"},"content":{"rendered":"<p><em>Article \u00e9crit par Numa Claudel<\/em><\/p>\n<p>Aujourd\u2019hui nous allons parler des requ\u00eates N+1 dans une application Rails&nbsp;: vous savez ces lignes quasiment identiques, qui s\u2019ajoutent de mani\u00e8re exponentielle aux logs, d\u00e8s lors que l\u2019on appelle les enfants d\u2019un objet \u00e0 l\u2019int\u00e9rieur d\u2019une boucle.<\/p>\n<p>Lorsque l\u2019on traite les donn\u00e9es relatives \u00e0 un objet, ActiveRecord fait une requ\u00eate en base de fa\u00e7on transparente au moment o\u00f9 il a besoin de donn\u00e9es enfants (<em>lazy loading<\/em>). Le syndrome de requ\u00eate N+1 r\u00e9sulte en une augmentation incontr\u00f4l\u00e9e de ces requ\u00eates, ce qui a pour cons\u00e9quence de ralentir l\u2019application. Et c\u2019est en consultant les journaux de Rails, que l\u2019on constate ce sympt\u00f4me.<\/p>\n<p>C\u2019est ici qu\u2019intervient <a href=\"https:\/\/github.com\/flyerhzm\/bullet\">Bullet<\/a>, qui va g\u00e9n\u00e9rer des messages d\u2019avertissement lorsque des requ\u00eates N+1 sont observ\u00e9es et nous faire son rapport.<\/p>\n<p>Il sera ainsi plus facile de d\u00e9tecter le code fautif, pour limiter ou r\u00e9sorber totalement ce syndrome via des bonnes pratiques que je m\u2019appr\u00eate \u00e0 vous pr\u00e9senter.<\/p>\n<h2 id=\"les-requtes-n1-et-comment-les-viter\">Les requ\u00eates N+1 et comment les \u00e9viter<\/h2>\n<p>Le <em>lazy loading<\/em> des donn\u00e9es est activ\u00e9 par d\u00e9faut dans Rails, ce qui \u00e9vite de charger des donn\u00e9es enfants non n\u00e9cessaires. Mais c\u2019est aussi la raison pour laquelle, lors de l\u2019acc\u00e8s aux attributs enfants dans une boucle, des requ\u00eates N+1 sont \u00e9mises.<\/p>\n<p>Prenons un cas simple pour illustrer ces propos&nbsp;:<\/p>\n<div class=\"language-ruby highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"k\">class<\/span> <span class=\"nc\">Article<\/span> <span class=\"o\">&lt;<\/span> <span class=\"no\">ActiveRecord<\/span><span class=\"o\">::<\/span><span class=\"no\">Base<\/span>   <span class=\"n\">belongs_to<\/span> <span class=\"ss\">:author<\/span> <span class=\"k\">end<\/span>  <span class=\"k\">class<\/span> <span class=\"nc\">Author<\/span> <span class=\"o\">&lt;<\/span> <span class=\"no\">ActiveRecord<\/span><span class=\"o\">::<\/span><span class=\"no\">Base<\/span>   <span class=\"n\">has_many<\/span> <span class=\"ss\">:articles<\/span> <span class=\"k\">end<\/span>  <span class=\"k\">class<\/span> <span class=\"nc\">ArticlesController<\/span> <span class=\"o\">&lt;<\/span> <span class=\"no\">ApplicationController<\/span>   <span class=\"k\">def<\/span> <span class=\"nf\">index<\/span>     <span class=\"vi\">@articles<\/span> <span class=\"o\">=<\/span> <span class=\"no\">Article<\/span><span class=\"p\">.<\/span><span class=\"nf\">all<\/span>   <span class=\"k\">end<\/span> <span class=\"k\">end<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"language-erb highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code># app\/views\/invoices\/index.html.erb <span class=\"cp\">&lt;%<\/span> <span class=\"vi\">@articles<\/span><span class=\"p\">.<\/span><span class=\"nf\">each<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">article<\/span><span class=\"o\">|<\/span> <span class=\"cp\">%&gt;<\/span>   <span class=\"cp\">&lt;%=<\/span> <span class=\"vi\">@article<\/span><span class=\"p\">.<\/span><span class=\"nf\">author<\/span><span class=\"p\">.<\/span><span class=\"nf\">name<\/span> <span class=\"cp\">%&gt;<\/span>   <span class=\"cp\">&lt;%=<\/span> <span class=\"vi\">@article<\/span><span class=\"p\">.<\/span><span class=\"nf\">text<\/span> <span class=\"cp\">%&gt;<\/span> <span class=\"cp\">&lt;%<\/span> <span class=\"k\">end<\/span> <span class=\"cp\">%&gt;<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>Cela va produire les fameuses requ\u00eates N+1 \u00e0 la consultation de la page&nbsp;:<\/p>\n<div class=\"language-bash highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code>Article Load <span class=\"o\">(<\/span>0.7ms<span class=\"o\">)<\/span> SELECT <span class=\"s1\">'articles'<\/span>.<span class=\"k\">*<\/span> FROM <span class=\"s1\">'articles'<\/span> Author Load <span class=\"o\">(<\/span>0.4ms<span class=\"o\">)<\/span> SELECT <span class=\"s1\">'authors'<\/span>.<span class=\"k\">*<\/span> FROM <span class=\"s1\">'authors'<\/span> WHERE <span class=\"s1\">'authors'<\/span>.<span class=\"s1\">'id'<\/span> <span class=\"o\">=<\/span> ?                     ORDER BY <span class=\"s1\">'authors'<\/span>.<span class=\"s1\">'id'<\/span> ASC LIMIT 1 <span class=\"o\">[[<\/span><span class=\"s2\">\"id\"<\/span>, 1]] Author Load <span class=\"o\">(<\/span>0.3ms<span class=\"o\">)<\/span> SELECT <span class=\"s1\">'authors'<\/span>.<span class=\"k\">*<\/span> FROM <span class=\"s1\">'authors'<\/span> WHERE <span class=\"s1\">'authors'<\/span>.<span class=\"s1\">'id'<\/span> <span class=\"o\">=<\/span> ?                     ORDER BY <span class=\"s1\">'authors'<\/span>.<span class=\"s1\">'id'<\/span> ASC LIMIT 1 <span class=\"o\">[[<\/span><span class=\"s2\">\"id\"<\/span>, 2]] Author Load <span class=\"o\">(<\/span>0.4ms<span class=\"o\">)<\/span> SELECT <span class=\"s1\">'authors'<\/span>.<span class=\"k\">*<\/span> FROM <span class=\"s1\">'authors'<\/span> WHERE <span class=\"s1\">'authors'<\/span>.<span class=\"s1\">'id'<\/span> <span class=\"o\">=<\/span> ?                     ORDER BY <span class=\"s1\">'authors'<\/span>.<span class=\"s1\">'id'<\/span> ASC LIMIT 1 <span class=\"o\">[[<\/span><span class=\"s2\">\"id\"<\/span>, 3]] Author Load <span class=\"o\">(<\/span>0.3ms<span class=\"o\">)<\/span> SELECT <span class=\"s1\">'authors'<\/span>.<span class=\"k\">*<\/span> FROM <span class=\"s1\">'authors'<\/span> WHERE <span class=\"s1\">'authors'<\/span>.<span class=\"s1\">'id'<\/span> <span class=\"o\">=<\/span> ?                     ORDER BY <span class=\"s1\">'authors'<\/span>.<span class=\"s1\">'id'<\/span> ASC LIMIT 1 <span class=\"o\">[[<\/span><span class=\"s2\">\"id\"<\/span>, 4]] \u2026 <\/code><\/pre>\n<\/div>\n<\/div>\n<p>Nous allons avoir ici autant de requ\u00eates que d\u2019articles. Si nous avons des milliers d\u2019articles, je vous laisse imaginer le temps de r\u00e9ponse de l\u2019application sur cette page.<\/p>\n<p>Heureusement, il suffit d\u2019ajouter une instruction <code>includes<\/code> (pour les auteurs) \u00e0 notre demande d\u2019articles, pour r\u00e9soudre le probl\u00e8me&nbsp;:<\/p>\n<div class=\"language-ruby highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"k\">class<\/span> <span class=\"nc\">ArticlesController<\/span> <span class=\"o\">&lt;<\/span> <span class=\"no\">ApplicationController<\/span>   <span class=\"k\">def<\/span> <span class=\"nf\">index<\/span>     <span class=\"vi\">@articles<\/span> <span class=\"o\">=<\/span> <span class=\"no\">Article<\/span><span class=\"p\">.<\/span><span class=\"nf\">includes<\/span><span class=\"p\">(<\/span><span class=\"ss\">:author<\/span><span class=\"p\">).<\/span><span class=\"nf\">all<\/span>   <span class=\"k\">end<\/span> <span class=\"k\">end<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>Nous obtenons ceci&nbsp;:<\/p>\n<div class=\"language-bash highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code>Article Load <span class=\"o\">(<\/span>0.7ms<span class=\"o\">)<\/span> SELECT <span class=\"s1\">'articles'<\/span>.<span class=\"k\">*<\/span> FROM <span class=\"s1\">'articles'<\/span> Author Load <span class=\"o\">(<\/span>0.11ms<span class=\"o\">)<\/span> SELECT <span class=\"s1\">'authors'<\/span>.<span class=\"k\">*<\/span> FROM <span class=\"s1\">'authors'<\/span> WHERE <span class=\"s1\">'authors'<\/span>.<span class=\"s1\">'id'<\/span> IN <span class=\"o\">(<\/span>1,2,3,4,\u2026<span class=\"o\">)<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>Ce qui est beaucoup mieux et moins couteux.<\/p>\n<p>Une deuxi\u00e8me solution serait de mettre en cache chaque objet parcouru par la boucle&nbsp;:<\/p>\n<div class=\"language-erb highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code># app\/views\/invoices\/index.html.erb <span class=\"cp\">&lt;%<\/span> <span class=\"vi\">@articles<\/span><span class=\"p\">.<\/span><span class=\"nf\">each<\/span> <span class=\"k\">do<\/span> <span class=\"o\">|<\/span><span class=\"n\">article<\/span><span class=\"o\">|<\/span> <span class=\"cp\">%&gt;<\/span>   <span class=\"cp\">&lt;%<\/span> <span class=\"n\">cache<\/span> <span class=\"n\">article<\/span> <span class=\"cp\">%&gt;<\/span>     <span class=\"cp\">&lt;%=<\/span> <span class=\"vi\">@article<\/span><span class=\"p\">.<\/span><span class=\"nf\">author<\/span><span class=\"p\">.<\/span><span class=\"nf\">name<\/span> <span class=\"cp\">%&gt;<\/span>     <span class=\"cp\">&lt;%=<\/span> <span class=\"vi\">@article<\/span><span class=\"p\">.<\/span><span class=\"nf\">text<\/span> <span class=\"cp\">%&gt;<\/span>   <span class=\"cp\">&lt;%<\/span> <span class=\"k\">end<\/span> <span class=\"cp\">%&gt;<\/span> <span class=\"cp\">&lt;%<\/span> <span class=\"k\">end<\/span> <span class=\"cp\">%&gt;<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>Ce qui donnerait (apr\u00e8s la premi\u00e8re mise en cache) :<\/p>\n<div class=\"language-bash highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code>Started GET <span class=\"s2\">\"\/articles\"<\/span> <span class=\"k\">for <\/span>0:0:0:0:0:0:0:1 at 2018-03-19 14:27:36 +0100 Processing by ArticlesController#index as HTML   Rendering articles\/index.html.erb within layouts\/application   Article Load <span class=\"o\">(<\/span>0.7ms<span class=\"o\">)<\/span> SELECT <span class=\"s1\">'articles'<\/span>.<span class=\"k\">*<\/span> FROM <span class=\"s1\">'articles'<\/span>   Read fragment views\/articles\/8158d13c8f5c84d1581e6bca35312319 <span class=\"o\">(<\/span>0.1ms<span class=\"o\">)<\/span>   Read fragment views\/articles\/f244d972216df100e804cecca2e53ed1 <span class=\"o\">(<\/span>0.1ms<span class=\"o\">)<\/span>   Read fragment views\/articles\/a9sy43nqs0ye7gnxbb51ym5rkgggx3ld <span class=\"o\">(<\/span>0.1ms<span class=\"o\">)<\/span>   Read fragment views\/articles\/bz5ytopxsj9rfe3irtwyvtbdv8z8fjo4 <span class=\"o\">(<\/span>0.1ms<span class=\"o\">)<\/span> \u2026 <\/code><\/pre>\n<\/div>\n<\/div>\n<p>Dans ce cas-l\u00e0, l\u2019instruction <code>includes<\/code> n\u2019est plus utile, puisque les donn\u00e9es sont d\u00e9sormais en cache. Cela aurait m\u00eame l\u2019effet inverse de celui recherch\u00e9, car des requ\u00eates inutiles seraient g\u00e9n\u00e9r\u00e9es.<\/p>\n<p>Pour voir le <em>fragment caching<\/em> en action en d\u00e9veloppement, il faut aussi penser \u00e0 activer cette option&nbsp;:<\/p>\n<div class=\"language-ruby highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"c1\"># config\/development.rb<\/span> <span class=\"n\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">action_controller<\/span><span class=\"p\">.<\/span><span class=\"nf\">perform_caching<\/span> <span class=\"o\">=<\/span> <span class=\"kp\">true<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>Il est donc relativement simple d\u2019\u00e9viter ces requ\u00eates N+1, mais toujours est-il que cela implique une vigilance r\u00e9guli\u00e8re, ainsi qu\u2019un contr\u00f4le des logs \u00e9mis.<\/p>\n<h2 id=\"comment-bullet-peut-nous-aider\">Comment Bullet peut nous aider<\/h2>\n<p>Bullet va pouvoir nous aider \u00e0 \u00eatre vigilants, car lui ne faillira pas. Bullet inspecte les logs \u00e0 notre place et fait la traque aux requ\u00eates N+1, pour ensuite nous faire son rapport. Ce rapport peut nous \u00eatre fourni de diff\u00e9rentes mani\u00e8res, sur diff\u00e9rents supports, il suffit de le param\u00e9trer en fonction de nos pr\u00e9f\u00e9rences.<\/p>\n<p>Voici \u00e0 quoi peut ressembler le rapport en question&nbsp;:<\/p>\n<div class=\"language-bash highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code>2018-03-15 15:45:58[WARN] user: numa \/articles N+1 Query detected   Article <span class=\"o\">=&gt;<\/span> <span class=\"o\">[<\/span>:author]   Add to your finder: :includes <span class=\"o\">=&gt;<\/span> <span class=\"o\">[<\/span>:author] N+1 Query method call stack   \/app\/controllers\/articles_controller.rb:3:in <span class=\"sb\">`<\/span>index<span class=\"s1\">' <\/span><\/code><\/pre>\n<\/div>\n<\/div>\n<p>C\u2019est tr\u00e8s pr\u00e9cis&nbsp;! Il nous suffit d\u2019aller \u00e0 l\u2019endroit indiqu\u00e9 et d\u2019appliquer le changement conseill\u00e9.<\/p>\n<p>Par ailleurs, Bullet conseille aussi de mettre en place des <code>counter_cache<\/code>, l\u00e0 ou \u00e7a lui semble n\u00e9cessaire. Et si nous avons eu un exc\u00e8s de z\u00e8le et avons appliqu\u00e9 des <code>includes<\/code> non n\u00e9cessaire, Bullet le d\u00e9tecte \u00e9galement et l\u2019inclut dans son rapport.<\/p>\n<h2 id=\"installer-et-paramtrer-bullet\">Installer et param\u00e9trer Bullet<\/h2>\n<p>Cela commence par&nbsp;:<\/p>\n<div class=\"language-ruby highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"n\">group<\/span> <span class=\"ss\">:development<\/span> <span class=\"k\">do<\/span>   <span class=\"n\">gem<\/span> <span class=\"s1\">'bullet'<\/span> <span class=\"k\">end<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>Puis un <code>bundle install<\/code> comme \u00e0 l\u2019accoutum\u00e9e.<\/p>\n<p>Il faut ensuite activer Bullet et le param\u00e9trer suivant nos cas d\u2019utilisation&nbsp;:<\/p>\n<div class=\"language-ruby highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"c1\"># config\/environments\/development.rb<\/span> <span class=\"n\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">after_initialize<\/span> <span class=\"k\">do<\/span>    <span class=\"no\">Bullet<\/span><span class=\"p\">.<\/span><span class=\"nf\">enable<\/span> <span class=\"o\">=<\/span> <span class=\"kp\">true<\/span> <span class=\"c1\"># active Bullet<\/span>    <span class=\"no\">Bullet<\/span><span class=\"p\">.<\/span><span class=\"nf\">bullet_logger<\/span> <span class=\"o\">=<\/span> <span class=\"kp\">true<\/span> <span class=\"c1\"># g\u00e9n\u00e8re des logs dans log\/bullet.log<\/span>    <span class=\"no\">Bullet<\/span><span class=\"p\">.<\/span><span class=\"nf\">console<\/span> <span class=\"o\">=<\/span> <span class=\"kp\">true<\/span> <span class=\"c1\"># g\u00e9n\u00e8re des warnings dans la console du navigateur<\/span>    <span class=\"no\">Bullet<\/span><span class=\"p\">.<\/span><span class=\"nf\">add_footer<\/span> <span class=\"o\">=<\/span> <span class=\"kp\">true<\/span> <span class=\"c1\"># ouvre un encart en bas \u00e0 gauche de la page consult\u00e9e<\/span> <span class=\"k\">end<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<p>J\u2019ai mis ici quelques options simples et utiles au quotidien, mais il y en a <a href=\"https:\/\/github.com\/flyerhzm\/bullet#configuration\">d\u2019autres qui peuvent \u00eatre plus indiqu\u00e9es<\/a>, en fonction de vos pr\u00e9f\u00e9rences et outils.<\/p>\n<p>Il est possible de profiter des tests pour d\u00e9tecter ces probl\u00e8mes de requ\u00eatage, en les faisant \u00e9chouer lorsque des anomalies sont observ\u00e9es. Pour faire cela, Bullet peut \u00e9mettre une erreur, ce qui aura l\u2019effet escompt\u00e9&nbsp;:<\/p>\n<div class=\"language-ruby highlighter-rouge\">\n<div class=\"highlight\">\n<pre class=\"highlight\"><code><span class=\"c1\"># config\/environments\/test.rb<\/span> <span class=\"n\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">after_initialize<\/span> <span class=\"k\">do<\/span>   <span class=\"no\">Bullet<\/span><span class=\"p\">.<\/span><span class=\"nf\">enable<\/span> <span class=\"o\">=<\/span> <span class=\"kp\">true<\/span> <span class=\"c1\"># active Bullet<\/span>   <span class=\"no\">Bullet<\/span><span class=\"p\">.<\/span><span class=\"nf\">bullet_logger<\/span> <span class=\"o\">=<\/span> <span class=\"kp\">true<\/span> <span class=\"c1\"># g\u00e9n\u00e8re des logs dans log\/bullet.log<\/span>   <span class=\"no\">Bullet<\/span><span class=\"p\">.<\/span><span class=\"nf\">raise<\/span> <span class=\"o\">=<\/span> <span class=\"kp\">true<\/span> <span class=\"c1\"># \u00e9met une erreur lors de la rencontre d'une anomalie de requ\u00eatage<\/span> <span class=\"k\">end<\/span> <\/code><\/pre>\n<\/div>\n<\/div>\n<h2 id=\"conclusion\">Conclusion<\/h2>\n<p><a href=\"https:\/\/github.com\/flyerhzm\/bullet\">Bullet<\/a> est donc un outil nous permettant de s\u2019all\u00e9ger l\u2019esprit. Gr\u00e2ce \u00e0 lui, les requ\u00eates N+1 viennent \u00e0 nous pendant la phase de d\u00e9veloppement. Cela fait donc gagner en temps et en s\u00e9r\u00e9nit\u00e9.<\/p>\n<p>On peut ex\u00e9cuter 1 requ\u00eate pour avoir 1000 r\u00e9sultats, mais on ne peut pas ex\u00e9cuter 1000 requ\u00eates\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Comment la gem Bullet peut nous aider \u00e0 visualiser les requ\u00eates N+1, et ainsi nous permettre de les corriger.<\/p>\n","protected":false},"author":10,"featured_media":10218,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[34],"tags":[],"class_list":["post-7802","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles-techniques"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Chasser les requ\u00eates N+1 avec Bullet - Ouidou<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez comment chasser les requ\u00eates N+1 avec Bullet, pour optimiser les performances de vos applications Ruby on Rails.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Chasser les requ\u00eates N+1 avec Bullet - Ouidou\" \/>\n<meta property=\"og:description\" content=\"D\u00e9couvrez comment chasser les requ\u00eates N+1 avec Bullet, pour optimiser les performances de vos applications Ruby on Rails.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet\" \/>\n<meta property=\"og:site_name\" content=\"Ouidou\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-04T22:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-22T09:37:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/04\/Blockchain-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1105\" \/>\n\t<meta property=\"og:image:height\" content=\"564\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sara Lourties\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sara Lourties\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet\"},\"author\":{\"name\":\"Sara Lourties\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/person\\\/e1d66085fb7c22ede319ce56adc373a4\"},\"headline\":\"Chasser les requ\u00eates N+1 avec Bullet\",\"datePublished\":\"2018-04-04T22:00:00+00:00\",\"dateModified\":\"2024-08-22T09:37:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet\"},\"wordCount\":759,\"publisher\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/Blockchain-3.png\",\"articleSection\":[\"Articles Techniques\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet\",\"name\":\"Chasser les requ\u00eates N+1 avec Bullet - Ouidou\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/Blockchain-3.png\",\"datePublished\":\"2018-04-04T22:00:00+00:00\",\"dateModified\":\"2024-08-22T09:37:59+00:00\",\"description\":\"D\u00e9couvrez comment chasser les requ\u00eates N+1 avec Bullet, pour optimiser les performances de vos applications Ruby on Rails.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet#primaryimage\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/Blockchain-3.png\",\"contentUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/Blockchain-3.png\",\"width\":1105,\"height\":564},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/articles-techniques\\\/chasser-les-requetes-n1-avec-bullet#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Chasser les requ\u00eates N+1 avec Bullet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/\",\"name\":\"Blog Ouidou\",\"description\":\"Conseil et expertise en technologies\",\"publisher\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#organization\",\"name\":\"Ouidou\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/image_2022-04-13_150237378.png\",\"contentUrl\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/image_2022-04-13_150237378.png\",\"width\":180,\"height\":180,\"caption\":\"Ouidou\"},\"image\":{\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ouidou.fr\\\/blog\\\/#\\\/schema\\\/person\\\/e1d66085fb7c22ede319ce56adc373a4\",\"name\":\"Sara Lourties\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g\",\"caption\":\"Sara Lourties\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Chasser les requ\u00eates N+1 avec Bullet - Ouidou","description":"D\u00e9couvrez comment chasser les requ\u00eates N+1 avec Bullet, pour optimiser les performances de vos applications Ruby on Rails.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet","og_locale":"fr_FR","og_type":"article","og_title":"Chasser les requ\u00eates N+1 avec Bullet - Ouidou","og_description":"D\u00e9couvrez comment chasser les requ\u00eates N+1 avec Bullet, pour optimiser les performances de vos applications Ruby on Rails.","og_url":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet","og_site_name":"Ouidou","article_published_time":"2018-04-04T22:00:00+00:00","article_modified_time":"2024-08-22T09:37:59+00:00","og_image":[{"width":1105,"height":564,"url":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/04\/Blockchain-3.png","type":"image\/png"}],"author":"Sara Lourties","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Sara Lourties","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet#article","isPartOf":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet"},"author":{"name":"Sara Lourties","@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/person\/e1d66085fb7c22ede319ce56adc373a4"},"headline":"Chasser les requ\u00eates N+1 avec Bullet","datePublished":"2018-04-04T22:00:00+00:00","dateModified":"2024-08-22T09:37:59+00:00","mainEntityOfPage":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet"},"wordCount":759,"publisher":{"@id":"https:\/\/ouidou.fr\/blog\/#organization"},"image":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet#primaryimage"},"thumbnailUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/04\/Blockchain-3.png","articleSection":["Articles Techniques"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet","url":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet","name":"Chasser les requ\u00eates N+1 avec Bullet - Ouidou","isPartOf":{"@id":"https:\/\/ouidou.fr\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet#primaryimage"},"image":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet#primaryimage"},"thumbnailUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/04\/Blockchain-3.png","datePublished":"2018-04-04T22:00:00+00:00","dateModified":"2024-08-22T09:37:59+00:00","description":"D\u00e9couvrez comment chasser les requ\u00eates N+1 avec Bullet, pour optimiser les performances de vos applications Ruby on Rails.","breadcrumb":{"@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet#primaryimage","url":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/04\/Blockchain-3.png","contentUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2018\/04\/Blockchain-3.png","width":1105,"height":564},{"@type":"BreadcrumbList","@id":"https:\/\/ouidou.fr\/blog\/articles-techniques\/chasser-les-requetes-n1-avec-bullet#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/ouidou.fr\/blog\/"},{"@type":"ListItem","position":2,"name":"Chasser les requ\u00eates N+1 avec Bullet"}]},{"@type":"WebSite","@id":"https:\/\/ouidou.fr\/blog\/#website","url":"https:\/\/ouidou.fr\/blog\/","name":"Blog Ouidou","description":"Conseil et expertise en technologies","publisher":{"@id":"https:\/\/ouidou.fr\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ouidou.fr\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/ouidou.fr\/blog\/#organization","name":"Ouidou","url":"https:\/\/ouidou.fr\/blog\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2022\/04\/image_2022-04-13_150237378.png","contentUrl":"https:\/\/ouidou.fr\/blog\/wp-content\/uploads\/2022\/04\/image_2022-04-13_150237378.png","width":180,"height":180,"caption":"Ouidou"},"image":{"@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ouidou.fr\/blog\/#\/schema\/person\/e1d66085fb7c22ede319ce56adc373a4","name":"Sara Lourties","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b2ef32f9fc1e16168b39587a2ec1dafedc70a9d41fa1b4a930ec7744b3e35ec7?s=96&d=mm&r=g","caption":"Sara Lourties"}}]}},"_links":{"self":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts\/7802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/comments?post=7802"}],"version-history":[{"count":3,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts\/7802\/revisions"}],"predecessor-version":[{"id":10265,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/posts\/7802\/revisions\/10265"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/media\/10218"}],"wp:attachment":[{"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/media?parent=7802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/categories?post=7802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ouidou.fr\/blog\/wp-json\/wp\/v2\/tags?post=7802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}