Skip to content

Instantly share code, notes, and snippets.

@pawel2105
Last active August 29, 2015 13:55
Show Gist options
  • Save pawel2105/8780769 to your computer and use it in GitHub Desktop.
Save pawel2105/8780769 to your computer and use it in GitHub Desktop.
Given the following domain and scenario:
Topic has_many votes
A rails noob that has a massive dataset but little understanding into ActiveRecord query methods
and little SQL knowledge.
Using elegant and idiomatic Ruby, what is a good solution for returning all topics sorted by the
number of votes they have. Because of the SQL knowledge gap, you should avoid having to use SQL directly.
@pixeltrix
Copy link

If you have 5 million topics and hundreds of votes each, surely you'd want the ordering to be done in the DB?

But if you do have 5 million rows any kind of SQL ordering sucks as well. In those circumstances I'd probably look at using a full-blown search engine.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment