Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at Scotch On The Rock (SOTR) 2010 (London) with: Andy Allan
Ben Nadel at Scotch On The Rock (SOTR) 2010 (London) with: Andy Allan

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 »