Community Member Profile

Recent Blog Comments By Jeffrey Bouley

• Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

  Posted on Mar 28, 2008 at 10:49 AM

  @William, so many points I don't know where to start 8-)... I'll try quoting what you said with my replies. "I get to leverage my constant variables in the SQL I wrote within the application" Who says you can't pass these app. constants as arguments to your proc? "The whole poin... read more »

• Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

  Posted on Mar 27, 2008 at 9:52 PM

  @Ben, totally agree on the bad sql in stored procs statement, my point was better to be bad and in the database than bad and in ColdFusion. @Zac, I couldn't disagree with you more. What is the benefit of seeing the actual sql in the debug output when you know where it is whether in CF or i... read more »

• Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

  Posted on Mar 27, 2008 at 5:09 PM

  Ben, I'd also like to add, always use stored procedures if possible. If you apply "separation of concerns" here, it is never a good idea to put sql in application code. Security and performance are an after thought regarding ColdFusion as well as it's integrated and forces data typing whic... read more »