News for hackers. Stuff that matters.
Re:Never use MongoDB (2013) by luhn on Monday February 01, 2021 @03:27PM (#25993379)
Author is using Rails, so my guess would be the bottleneck is ActiveRecord. I've never used ActiveRecord, so I can't speak to it directly, but in my experience when dealing with large numbers of records in an ORM (and author easily is working with hundreds of thousands), things grind to a halt, even with eager loading. There's a lot more overhead to create thousands of ORM objects than it is to serialize an equivalent chunk of BSON.
Re:Never use MongoDB (2013) by treeman79 on Monday February 01, 2021 @03:45PM (#25993655)
Bulk operations are were a lot of rails programmers struggle.

Active record is awesome in many ways, but it can shoehorn you into n+1 solutions.

Re:Never use MongoDB (2013) by vidugavia on Tuesday February 02, 2021 @12:35AM (#25997751)
12k is not a large number of records though
Re:Never use MongoDB (2013) by luhn on Tuesday February 02, 2021 @11:39AM (#26003128)
12k episodes, each with cast list and reviews. That's easily hundreds of thousands of records, possibly millions.