This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
So I get asked a lot when working with data that comes from a database what the best way to process that data is, on the database or on the server.
For example if you want a column to be trimmed you can use TRIM in the SQL or .Trim() in C#. There might be some times you want two columns concatenated. You can have a third column that concatenates them or do it in the application.
What method do you prefer? I usually go with whatever results in the least amount of calls to the database, with the exception of if the database way cause the query to run significantly slower. I also prefer working with dates server side.
Subreddit
Post Details
- Posted
- 4 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/computersci...