Mar 01, 2019 07:52 PM|deepalgorithm|LINK
APIs that move heavy amounts of data consume a lot of memory to materialize results which can lead to high memory usage, paging, and sluggish performance. With this in mind, you want to implement a streaming approach. Assuming your datasource can stream
results, you can keep more memory available on the server by moving data with
IQueryable to the client.
The projects I'm on that require massive data ingestion leverage services like
Azure Event Hubs. What you decide to do comes down to the architecture and overall system requirements.