Skip to main content
Ben Nadel at InVision In Real Life (IRL) 2018 (Hollywood, CA) with: Scott Van Hess
Ben Nadel at InVision In Real Life (IRL) 2018 (Hollywood, CA) with: Scott Van Hess

john venable

Member since Jun 14, 2011

Recent Blog Comments By john venable

  • ColdFusion Query-Of-Queries vs. The Group Attribute In CFOutput

    Posted on Jun 14, 2011 at 1:51 PM

    I am by no means a DB ninja, but i've worked with some and it's amazing what you can get back from the database if you know the rights functions. My current favorite is the Over() function which lets you do things like aggregate data on parts of your query. I originally encountered it when I was try... read more »

  • ColdFusion Query-Of-Queries vs. The Group Attribute In CFOutput

    Posted on Jun 14, 2011 at 1:28 PM

    @marcin, sorry if i was rude, i've rewritten more queries within loops code than I'd care to remember. apologies. J... read more »

  • ColdFusion Query-Of-Queries vs. The Group Attribute In CFOutput

    Posted on Jun 14, 2011 at 1:27 PM

    @marcin, your approach definitely works, but you are opening two DB connections to bring back a single record each for each row of your original query. That's just incredibly inefficient. I've seen custom code like that get to tens of thousands of queries on a single page as the original query's num... read more »

  • ColdFusion Query-Of-Queries vs. The Group Attribute In CFOutput

    Posted on Jun 14, 2011 at 1:14 PM

    Ben, did you do any speed testing on either of these? I'd be curious as to the load for each. I would put myself in the GROUP camp just because it seems simpler, but maybe that's because I started before QoQ existed. I'm also a big proponent of letting the database do what the database do. In SQL S... 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