Business Logic, Logic Puzzles, Logic Games, Pretzel Logic...
All a whole bunch of fun, but in my particular case it's the Business Logic portion that I'm worried about. Should all or some of the Business Logic be on or off the database? I had this discussion a few years ago, but it's been awhile and I can't remember much of it now.
What do you think?
Is the cost of one select statement round trip from a web server to a database server so much that over time it will decrease efficiency, or is it negligable?
Where should the business logic go?