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 cf.Objective() 2010 (Minneapolis, MN) with: Doug Hughes and Ezra Parker and Dan Wilson and John Mason and Jason Dean and Luis Majano and Mark Mandel and Brian Kotek and Wil Genovese and Rob Brooks-Bilson and Andy Matthews and Simeon Bateman and Ray Camden and Chris Rockett and Joe Bernard and Dan Skaggs and Byron Raines and Barney Boisvert and Simon Free and Steve 'Cutter' Blades and Seth Bienek and Katie Bienek

Akansha

Member since Aug 3, 2010

Recent Blog Comments By Akansha

  • SQL Optimization And ON Clause vs WHERE Clause

    Posted on Aug 3, 2010 at 4:56 AM

    Its taking couple of hours to execute the below query. Both tables have millions of entries and index is on col1, col3 and col4 of tableB. What can I do to make it run fast? update tableA,tableB set tableA.col2 = 1 where tableA.col1 = tableB.col1 and (tableA.col3 < 100 or tableA.col4 >200);... read more »