Ask A Question

Notifications

You’re not receiving notifications from this thread.

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

Boris Bresciani asked in Databases

Hi,

I have 4 models:

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

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

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 !

Boris

Reply

Any ?

Reply
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.