IAsyncEnumerable<T> in C#: Streaming Data Without Loading Everything into Memory

My API crashed in production. 500,000 database records, a List, and a server with 8GB RAM. The math...