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


Member since Feb 9, 2009

Recent Blog Comments By kaos

  • SQL User Defined Functions Are Slower Than Inline Logic

    Posted on Feb 9, 2009 at 10:49 AM

    I can confirm that UDFs (table functions - not scalar) are up to 4x slower than inline SQL logic. I just created an UDF with a simple select statement. It takes 60s+ to complete while the plain select statement is finished after 15s. I have no idea how this MAY happen.... read more »