News for hackers. Stuff that matters.

A comment on GitHub has 11,995,200 open issues. Parent comment

Re:GitHub has 11,995,200 open issues by siddhant on Wednesday April 27, 2016 @05:31AM (#11578904)
Probably off topic, but how do you get such a sort to work nicely (sorting on count from another table), without creating redundant data (in this case, maintaining the +1 count in the main issue table as well as maintaining a separate table for +1s), or just delegating the sort to an external search service?
[ Parent | on HN ]
Re:GitHub has 11,995,200 open issues by takno on Wednesday April 27, 2016 @06:28AM (#11579174)
There's no obvious reason why it would be particularly slow to get counts from another table. You're probably going to want to offer full text searches and searches on columns you wouldn't choose to index online as well though, at which point using a search service makes most sense
[ Parent | on HN ]