Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Cara Beverage and Taraneh Kossari
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Cara Beverage@caraphernalia ) and Taraneh Kossari

McNicholl

Member since Apr 14, 2009

Recent Blog Comments By McNicholl

  • SQL Optimization And ON Clause vs WHERE Clause

    Posted on Apr 14, 2009 at 4:23 AM

    Stop using INNER JOIN in the FROM clause for your first test. That is the whole point of what you are trying to test and confirm. Your FROM clause in the first instance should be: FROM web_stats_hit h, web_stats_url u, web_stats_session s, web_stats_user_agent a ... move the ON statements i... read more »