In my experience, the database is the best place to perform optimizations, not in the code. I guess a lot depends on what you are doing.