Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Andy Matthews and Todd Sharp and Jason Dean and Simon Free
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Andy Matthews@commadelimited ) , Todd Sharp@cfsilence ) , Jason Dean@JasonPDean ) , and Simon Free@simonfree )

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 »