Fetching 50k rows is a nobrainer, neither speed nor memory wise. Relational db-s are super fast when used properly