Ask A Question


You’re not receiving notifications from this thread.

How can I improve query time in SQL ? (PostgreSQL)

Boris Bresciani asked in Databases


I have 4 models:

class Match < ApplicationRecord
  belongs_to :tournament
  scope :next, -> { where('date > ?', }
class Tournament < ApplicationRecord
  belongs_to :region
  has_many :matches, dependent: :destroy
class Region < ApplicationRecord
  belongs_to :sport
  has_many :tournaments, dependent: :destroy
  has_many :matches, through: :tournaments
class Sport < ApplicationRecord
  has_many :regions, dependent: :destroy
  has_many :matches, through: :regions

I'm looking for the number of matches in the future from Sport, so actually i do this:

But my problem is that sometimes it's very long to look for it especially when I have a lot of data (well it's normal) but I'm trying to optimize)

Thank you for your help !



Any ?

Join the discussion
Create an account Log in

Want to stay up-to-date with Ruby on Rails?

Join 79,047+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more.

    © 2023 GoRails, LLC. All rights reserved.