Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


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 »