Thanks Joe, that's pretty much where I was headed too, with the possible/probable exception of using something IBO-like to leverage objects while iterating over a query. I grew up w SQL, never wanted something to "just make it go away", but clearly life should be domain-object-centric, not db-centric.
Still haven't heard from anyone actually in production with a large-scale ORM app yet. Maybe there just aren't any out there, around a year after CF 9.0. Or maybe they don't read this list, at least this quickly. We'll see... Dave On Fri, Oct 22, 2010 at 11:15 AM, Joe Rinehart <j...@firemoss.com> wrote: > > The rule of thumb we (myself, Brian Kotek, Marc Esher, and Scott > Stroz) are using on our first large CF ORM project is: > > 1. If a service is working with changing data, use ORM. > 2. If an operation largely works with one item (e.g. a form or detail > page), use ORM. > 3. If we're going to show a list of things, especially across tables, > get off our butts and write a decent SELECT statement to return a > query. > > The common argument against using a select/vanilla query is "What it > the getters in my objects model formatting/custom logic?" Our > response to that is to factor that logic into a helper class that is > a) used by the object and b) used where the query is cfoutput'd. > > -Joe > > > On Fri, Oct 22, 2010 at 8:44 AM, enigment <enigm...@gmail.com> wrote: >> >> Just starting to look at the CF ORM stuff, pretty nice API, Hibernate >> underneath, all good. >> >> But as I understand it, ORM "queries" return arrays of cfc objects, >> and I'm concerned about performance at scale. On a gut level, I'd >> rather be able to get a native CF query, which I could deal with in >> straight CF as usual, or through an IBO if I wanted object-like >> behavior for that whole collection. >> >> So... >> >> - Is it possible to have CF ORM return a query, when I want it to? >> >> - What's people's experience with this stuff at scale, meaning large >> result sets, more than departmental traffic etc? Are there any largish >> sites doing that? >> >> Thanks, >> Dave >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm