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

Tjie Parta

Member since Dec 9, 2010

Recent Blog Comments By Tjie Parta

  • SQL IN Directive Much Faster Than Multiple OR Clauses

    Posted on Dec 9, 2010 at 3:30 AM

    I've been wondering it myself and want to find out about it. But in my test, the Or clause is faster than the In clause. The number of records is millions (all data in the table not the result set. the result set should be hundreds to thousands) But there's only 2 condition. Not many. I suppose t... read more »