When I used Distinctby() the memory consumption of console app rises up to 1.5GB.
When I used Groupby(), the service took 100MB max. so keeping it to SQL Server side is more efficient or processing data at code level is more efficient?
New contributor
Shiraz Ahmed is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
5
For larger datasets it is better to process data at the sql server side which would result in better performance and scalablity