john venable

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 »