Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Scott Stroz and Vicky Ryder and Ray Camden and Todd Sharp
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Scott Stroz@boyzoid ) , Vicky Ryder@fuzie ) , Ray Camden@cfjedimaster ) , and Todd Sharp@cfsilence )

John Bevilaqua

Member since Sep 2, 2011

Recent Blog Comments By John Bevilaqua

  • SQL Optimization And ON Clause vs WHERE Clause

    Posted on Sep 2, 2011 at 10:13 AM

    Writing the code with 4 Equi-Joins followed immediately by only the WHERE clause statements applicable to the current Equi-Join was palpably slower than the optimized alternative: Creating 4 INNER JOINS, eliminating most of the WHERE clauses and listing the remaining ones at the bottom of the INNER ... read more »