Re: ORM question

2010-01-18 Thread Victor Moore
I think I will stick with one load per call and probably will end up saving it in the application scope so it's available in other places as needed. Thank you Victor On Mon, Jan 18, 2010 at 2:06 AM, Barney Boisvert bboisv...@gmail.com wrote: It does solve the problem, but has pretty

Re: ORM question

2010-01-18 Thread Barney Boisvert
You should virtually never cache ORM-managed instances anywhere. Their state MUST be managed by the ORM framework, or you run into all kinds of crazy issues. If you simply must cache one (a common-ish use case is for business-level transactions where you need to keep modified persistent

Re: ORM question

2010-01-18 Thread Dave Watts
You should virtually never cache ORM-managed instances anywhere. Their state MUST be managed by the ORM framework, or you run into all kinds of crazy issues.  If you simply must cache one (a common-ish use case is for business-level transactions where you need to keep modified persistent

Re: ORM question

2010-01-18 Thread Victor Moore
Good to know. This is exactly the stuff I was talking about. Using old tricks with new dogs :) Before, I as just running the query at application start up, loading it in app scope (I need it for read only purposes anyway) and use it whenever i need it. It changes very rarely but when changes I

Re: ORM question

2010-01-17 Thread Victor Moore
Hi Barney, After trying to find the answer to the question for almost a day I was afraid that the answer is no but just wanted to be sure :) The reason I want only a few is for display purposes. Just to give some indication to users the type of subcategories exists. While I like the idea of

Re: ORM question

2010-01-17 Thread Barney Boisvert
If you subCategories collections are relatively small, then you should be safe to just loop over it and terminate after the third row. Yeah, you'll be getting more than you need back from the database, but Hibernate is really good about optimizing data access for relationships, so I'd assume it

Re: ORM question

2010-01-17 Thread Raymond Camden
According to this posty, http://www.rupeshk.org/blog/index.php/2009/09/coldfusion-orm-performance-tuning-lazy-loading/, if you use lazy=proxy, you would only load the objects you use. So if you only displayed the first three, then only the first three would be loaded. On Sun, Jan 17, 2010 at

Re: ORM question

2010-01-17 Thread Barney Boisvert
lazy=proxy gives you N+1 behaviour for your collection. That is, if you need a Category and it's 10 subcategories, you'll end up doing 11 queries (one to retrieve each row individually). Of course, if you only use the category and three children you'll only run 4 queries. But if you do an eager

Re: ORM question

2010-01-17 Thread Raymond Camden
I'm confused - are you saying this _doesn't_ solve the problem - or has side effects if he doesn't use it as described? Or are you saying that it is best to just get em all at once? On Sun, Jan 17, 2010 at 10:19 PM, Barney Boisvert bboisv...@gmail.com wrote: lazy=proxy gives you N+1 behaviour

Re: ORM question

2010-01-17 Thread Barney Boisvert
It does solve the problem, but has pretty significant performance implications in common use cases, which is why it's not the default. Obviously it's hard to say what is best without seeing the code, but I'd say the default (just get them all) is probably best, unless the category tree

Re: ORM question

2010-01-16 Thread Barney Boisvert
The short answer is no. The long answer is that yeah, you can do a whole bunch of hacking around to make it work like that (or at least APPEAR to work like that), but it's a mess. I can't think of a case when you wouldn't be better off a) just constraining the loop over the subcategories when

Re: ORM Question

2007-02-21 Thread Nathan Strutz
You're too kind :) On 2/20/07, Dinner [EMAIL PROTECTED] wrote: Yup, that was the one! Mr. Nate- YOU ROCK. On 2/20/07, Rob Wilkerson [EMAIL PROTECTED] wrote: This one, perhaps? http://www.dopefly.com/techblog/entry.cfm?entry=149 Once you said something, it occurred to me that I

Re: ORM Question

2007-02-21 Thread Dinner
On 2/21/07, Nathan Strutz @gmail.com wrote: You're too kind :) Not by half! ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/

Re: ORM Question

2007-02-20 Thread Teddy Payne
Reactor does not generate data table. I have not used Transfer as yet. There is a CF Hibernate open source project here: http://cfopen.org/projects/cfhibernate/ I am not sure how active that project is though. Teddy On 2/20/07, Rob Wilkerson [EMAIL PROTECTED] wrote: I've been digging

Re: ORM Question

2007-02-20 Thread Tom McNeer
Rob, Reactor and Transfer operate in the reverse of what you're looking for: they introspect the existing database to create DAOs, Gateways, TOs, etc. Reactor (probably Transfer, too; I'm just not sure) can also create aliases for your column names, if you define them in the XML config. But if

Re: ORM Question

2007-02-20 Thread Steve Bryant
Rob, Apologies for the self-promotion, but I have a (free) tool that does this (though it isn't technically an ORM tool). blog: http://steve.coldfusionjournal.com/create_tables_with_data.htm see the Synchronize Database Structure presentation:

Re: ORM Question

2007-02-20 Thread Nick Tong - TalkWebSolutions.co.uk
Slightly off topic but if you want to understand a little more about transfer Mark Mandel (transfer creator) has just been interviewed on cfFrameworks.com. Heres the link: http://www.cfframeworks.com/blog/index.cfm/2007/2/20/Mark-Mandel-talks-about-his-Transfer-ORM-Framework HTH On 20/02/07,

Re: ORM Question

2007-02-20 Thread Rob Wilkerson
Thanks, all. Since I saw no evidence that either tool would do this, I thought I'd ask, but since I also didn't see any evidence with Hibernate...well, it does it, maybe other tools just don't market that capability either. I guess that's not the case. Nick, I'll definitely look at the

Re: ORM Question

2007-02-20 Thread Steve Bryant
Rob, If you are looking for Transfer presentations, Mark links to a few from the Getting Started page of his documentation: http://www.compoundtheory.com/transfer/documentation/gettingStarted.html Steve Nick, I'll definitely look at the interview with Mark. I've also heard about at least one

Re: ORM Question

2007-02-20 Thread Dinner
On 2/20/07, Rob Wilkerson @gmail.com wrote: Thanks, all. Since I saw no evidence that either tool would do this, You know, someone had blogged about using the generated reactor info to reverse the process-- they'd accidentally blown away the DB and were able to re-create it using the

Re: ORM Question

2007-02-20 Thread Rob Wilkerson
This one, perhaps? http://www.dopefly.com/techblog/entry.cfm?entry=149 Once you said something, it occurred to me that I had seen a similar post, as well... On 2/20/07, Dinner [EMAIL PROTECTED] wrote: On 2/20/07, Rob Wilkerson @gmail.com wrote: Thanks, all. Since I saw no evidence that

Re: ORM Question

2007-02-20 Thread Dinner
Yup, that was the one! Mr. Nate- YOU ROCK. On 2/20/07, Rob Wilkerson [EMAIL PROTECTED] wrote: This one, perhaps? http://www.dopefly.com/techblog/entry.cfm?entry=149 Once you said something, it occurred to me that I had seen a similar post, as well...