Out of curiosity, Joe, are you writing vanilla SQL selects or are you using hibernate HSQL for the selects? Do you have a reason one way or the other?
Cheers, Judah On Fri, Oct 22, 2010 at 8: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:338483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm