Rails使用 include 和 join 避免 N+1 query

May 10, 2015

Rails當中要連結model之間的關係非常簡單，不過也因為由於建立關係是這樣的簡便，造成許多指令會在讀取資料庫時有記憶體的浪費。例如我們建立以下關係：

Comments

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts

Tokyo Tech Lead

Rails使用 include 和 join 避免 N+1 query