+1 to what Matt said -

This is why there are so many discard options:
http://docs.transfer-orm.com/wiki/Managing_the_Cache.cfm#Transfer.discardByClassAndKeyQuery(className%2C_keyQuery%2C_columnName)

Mark

On Sat, Dec 19, 2009 at 3:47 AM, Matt Quackenbush <[email protected]>wrote:

> I have not read through the entire thread, but based upon your
> statement about SQL vs. a loop I would say just do it in SQL and then
> discard the affeced objects from the Transfer cache.
>
> HTH
>
> On Friday, December 18, 2009, pedrobl <[email protected]> wrote:
> >
> > I guess there's no way to do this easily with transfer... As I said in
> > my first email, right now you need to loop through all relations, and
> > set each foreign to the other one.
> >
> > From my point of view, this is unacceptable, specially when there's
> > such a better alternative, the good old UPDATE that gets this done in
> > one SQL sentence. :(
> >
> > I have tried the looping, and it has a horrible performance.
> >
> > Happy holidays everyone! :)
> >
> > Pedro.
> >
> > --
> > Before posting questions to the group please read:
> >
> http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
> >
> > You received this message because you are subscribed to the Google Groups
> "transfer-dev" group.
> > To post to this group, send email to [email protected]
> > To unsubscribe from this group, send email to
> [email protected]
> > For more options, visit this group at
> http://groups.google.com/group/transfer-dev?hl=en
>
> --
> Before posting questions to the group please read:
>
> http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
>
> You received this message because you are subscribed to the Google Groups
> "transfer-dev" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/transfer-dev?hl=en
>



-- 
E: [email protected]
T: http://www.twitter.com/neurotic
W: www.compoundtheory.com

-- 
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en

Reply via email to