although i dont have much experience, but in terms of organization and logical thinking i am a big fan of putting bussiness logic just in BLL layer and against putting any business logic in stored procedures.
i am starting a new project now and not planning to put any business logic in stored procedures however i have some performance concerns, if i have some business operation that needs to check say 4 pieces of data from database while executing, if i made this operation as a stored procedure, i will visit database once, but if i made it in business layer i will have to visit database 4 times.
could this have an unforgivable implication on my application performance?