Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with:

David Hammond

Member since Oct 19, 2009

Recent Blog Comments By David Hammond

  • Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement

    Posted on Aug 19, 2011 at 11:24 AM

    @Ben A lot of it depends on what proportion of user records have corresponding profile records. If most of them do, then exists should perform well. If most of them don't, not so much. I'm guessing that the reason your insert/delete method works well is that there aren't that many records to del... read more »

  • Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement

    Posted on Aug 19, 2011 at 11:06 AM

    Not sure if it would be any different from JoeM's query, but my first instinct would be to use an exists subquery: insert into guest(id, name) select u.id, u.name from user u where not exists ( select * from profile where userID = u.userID )... read more »

  • Using Slice(), Substring(), And Substr() In Javascript

    Posted on Mar 28, 2011 at 11:13 AM

    I'm with you -- I never even noticed the string slice() method before for some reason. Thanks for pointing it out! I've always just used the substring method, but the ability to use negative indexes could definitely come in handy. There are probably cases where you might want any negative numbe... read more »

  • The User Experience (UX) Of Comments vs. Conversation

    Posted on Oct 10, 2010 at 5:33 PM

    Wow, I must really be out of it because I had no idea that "inline" blog comments were going away. I guess I'm backwards anyway, because I'm not into Twitter and if I have anything useful to say, I usually can't express it in 140 characters or less. In other words, I totally agree with y... read more »

  • Creating A "Down For Maintenance" Page Using Application.cfc

    Posted on Oct 19, 2009 at 1:10 PM

    Well, to follow up on my previous comment ... I tried the same thing on the different server and "The service is unavailable." was not included in the response body. The only significant difference between the two servers that I can think of is that the one displaying the text is Windows 2008, and... read more »

  • Creating A "Down For Maintenance" Page Using Application.cfc

    Posted on Oct 19, 2009 at 12:15 PM

    This is very helpful. One minor problem I came across is that setting the status code to 503 seems to automatically output "The service is unavailable." to the body of the response as well as the header. Since the site I'm working on has to be down for a significant amount of time, and I have a pr... read more »