Re:Does Hacker News sort trending topics on-the-fly or as a ...
by mcassagnes on Friday July 03, 2015 @07:11PM
(#9828402)
Do you have any source for this? I'd love to know more about how they re rank items incrementally.
Do they actually update every single row in the database every 5 minutes? It seems too slow.
Re:Does Hacker News sort trending topics on-the-fly or as a ...
by snowwrestler on Friday July 03, 2015 @07:16PM
(#9828420)
Source: dang is one of the employees of Y Combinator who help run HN.
Dang--might be good to have some way to indicate that so new folks understand your special role in the community here
Re:Does Hacker News sort trending topics on-the-fly or as a ...
by dangrossman on Friday July 03, 2015 @07:31PM
(#9828470)
HN doesn't use a database. There are no rows. Just one process on one server with everything in memory. Data is lazy loaded from flat files on-demand.
Re:Does Hacker News sort trending topics on-the-fly or as a ...
by krapp on Friday July 03, 2015 @07:57PM
(#9828547)
I assumed that in memory they had something structurally resembling a relational database but they might not. It would never even occur to me to not use a database for something like this.
Re:Does Hacker News sort trending topics on-the-fly or as a ...
by mcassagnes on Friday July 03, 2015 @10:46PM
(#9828932)
Thank you. I did not expect that!
I'd love to get to the point where we can sort everything on every request.