ColdFusion Server Side Query vs. SQL Server View - Which is Faster \ Best Practice
Posted on 2009-05-07
I've been asked to help with a ColdFusion website, and I'm still a novice, but there is one thing the main developer does that I find odd (well, there are many things he does that I don't agree with, but that's beside the point). Anyways, he does not have one view in his SQL Server db; he recreates the queries in every page that pulls data, and that includes 90%+ of the pages.
I know it makes since to create queries in some of the pages, especially when they are only going to be used once, but I would think it would be better to create the majority of the queries in the SQL Server, and then simply call them in.
What is the best practice to follow? Which is faster, having the ColdFusion server do the work, or allowing the SQL Server to do the work?