Skip to main content
Ben Nadel at the New York ColdFusion User Group (Mar. 2009) with: Aaron Foss and Simon Free
Ben Nadel at the New York ColdFusion User Group (Mar. 2009) with: Aaron Foss ( @aaronfoss ) 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 »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel