[transfer-dev] Re: ManyToMany Relationships order property not working

2009-03-13 Thread Mark Mandel
Chris, What does the rest of the config for that object look like? Mark On Fri, Mar 13, 2009 at 2:52 AM, Chris H 3darkli...@gmail.com wrote: yes, i first had it in the ProjekteBilder Table, which did throw an error. it is now in the Bilder Table and no errors is thrown, but the resulting

[transfer-dev] Re: Trouble with Cache settings

2009-03-13 Thread Nando
Its an extensive web app to manage information related to traditional chinese medicine that I've been developing for a client for quite some time. On Fri, Mar 13, 2009 at 1:20 AM, Bob Silverberg bob.silverb...@gmail.comwrote: Np. Btw, what the heck is all this Herb stuff that continually

[transfer-dev] Re: ManyToMany Relationships order property not working

2009-03-13 Thread Chris H
Hey Mark, here are the relevant declarations: object name=Bilder id name=BildID type=numeric / property name=Filename type=string / property name=OrderNum type=numeric / /object !-- PROJEKTE -- package name=Projekte object name=Projekte decorator=athome.model.ProjekteDecorator id

[transfer-dev] Re: ManyToMany Relationships order property not working

2009-03-13 Thread Chris H
never mind, i was updating the order column with manual SQL and of course the cache didn't pick this up. still have to wrap my head around this new workflow with Transfer ;D i called discardByClassAndKey() on the parent object after the manual update and all is good now. thanks for all your

[transfer-dev] Decorator after populate method?

2009-03-13 Thread John Whish
Hi, I know there is the configure method of a decorator which runs before the object is populated. Is there a method that runs after the object is populated? I have a onetomany relationship which creates lots of objects which are basically a name-value pair, which could have a performance impact

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread John Whish
Hi Brian, I might be going down completely the wrong path with this. I'm expecting 200,000 users logged in at once. The idea is to encapsulate what changes and stick all user attributes that aren't common to all users into another class. Users will probably only have 3-4 specific attributes

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread John Whish
I had thought about doing a good ol' cfquery to pull out the values from the db and just populate that way. Would certainly be quick. --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread Bob Silverberg
I think it might even make more sense, because I'm not sure that you're going to get any value from composition anyway. It doesn't sound like you have a bunch of actual objects composed into your User object, but rather a bunch of properties. So it might make more sense to treat them as

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread John Whish
Hi Bob, yeah the objects are completely dumb so there is not value to using composition. Using a query just seemed a bit hacky to me, having said that if you think it's OK, then it's definitely good enough for me :) Thanks for your thoughts. --~--~-~--~~~---~--~~

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread John Whish
Another solution I thought of was to just have all the getters and setters for all the users properties which would be unused for most users. That doesn't seem very clean to me either. --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread John Whish
@Adam, that TIBO sounds interesting. Does it pick up the 'custom' behaviour from the decorator or do you end up duplicating code? --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread Adam Drew
Yes... basically it wraps the TransferDecorator using CF8's onMissingMethod() functionality I would suggest that if you haven't yet, go check out the work Peter Bell did with the coldfusion IBO on riaforge.org.. The TIBO started as a slightly modified IBO, it now has a fairly similar

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread Brian Kotek
If any individual User only has a few attributes, then a oneToMany is fine. If a User had 5,000 attributes, it would not be fine. 200,000 instances is a lot, but a lot depends on your hardware, RAM, heap size, etc. With 200,000 simultaneous connections, I'm assuming this is a monster server. So

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread Peter Bell
I haven't done any load testing on ColdFusion or Transfer with anywhere near that number of users, but as Brian said I'd do a really quick spike and some load testing before you go too far with this. Mark, shoot me down if I'm wrong, but I wouldn't call that number of simultaneous users a

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread Adam Drew
Thanks Brian.. your response is in line with my general understanding of the o2m vs m2o relationships, and I was by no means blaming Transfer for anything. I think I hijacked the thread and took it off topic, but your post reminds me of a good blog I read and must have forgotten about o2m vs

[transfer-dev] Find values NOT IN a manytomany table

2009-03-13 Thread David Mineer
I have this object object name=edition table=tblEdition decorator=com.beans.edition id name=id column=editionid type=numeric/ property name=description type=string/ property name=constructiontype type=string/ property name=price type=numeric/ manytoone name=area lazy=true link to=area.area

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread Mark Mandel
Yeah... I have to wonder at 200,000 simultaneous single users on a single server, regardless of the application server, let alone the framework. If you have that high a load, I'd be looking at a clustered solution right off the bat. Would anyone disagree with me? Mark On Sat, Mar 14, 2009 at

[transfer-dev] Re: Decorator after populate method?

2009-03-13 Thread Brian Kotek
Either a cluster of separate servers or a monster system running numerous instances. On Fri, Mar 13, 2009 at 7:37 PM, Mark Mandel mark.man...@gmail.com wrote: Yeah... I have to wonder at 200,000 simultaneous single users on a single server, regardless of the application server, let alone the

[transfer-dev] Re: Find values NOT IN a manytomany table

2009-03-13 Thread Mark Mandel
This is off the top of my head, but something similar should work in TQL: from area.county as country where country.countyid NOT IN (select subCounty.countryid from edition join subCounty where edition.id = :id) You can do sub selects within IN statements, so this should work: