Skip to content

Instantly share code, notes, and snippets.

@brunomichetti

brunomichetti/efficient-counter-caches-ex12.rb Secret

Created August 27, 2019 19:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save brunomichetti/dfb476810f5bf8796887e7ea3508a480 to your computer and use it in GitHub Desktop.
Save brunomichetti/dfb476810f5bf8796887e7ea3508a480 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
efficient-counter-caches-ex12.rb
Influencer Load (2.1ms) SELECT influencers.*,
(
SELECT COUNT(fan_influencers.id) FROM fan_influencers
WHERE influencer_id = influencers.id
) AS fans_count
FROM "influencers"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment