The propertis can change or add in the future so I could't come with other designe to store values for each document property then having a intermediate table for that with many-to-many relation and value.
Can you send me some links for caching the AR results?
Thank you for the resplay.
Mircea
This shouldn't have much effect. I'm using similar methods in several places, and I have not seen any perf problems.
In general, the DB should handle this easily, it is a join and a select, simple stuff mostly.
Throw some caching into the deal, and you will have smooth sailing.
How often are you adding a new property, anyway? Does it make sense to have dynamic properties?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mircea Jivoin
Sent: Saturday, June 17, 2006 2:39 PM
To: [email protected]
Subject: Re: [Castle-users] Use AR to dynamicaly create new table column
Yes is a nasty thing to do.
But my scenario is next:
I have a table of documents, a table of properties and a table of property values.
The initial approach to this was using a stored procedure that created a new column for each new property added in property table.
But when I transferred to the AR I simply mapped as many-to-many with value table.
Now my concern is the table size and it's performance.
Can I go like this with AR map?
The values table will grow like hell, what is your experience with this approach?
Thanks for any comments.
MirceaOn 6/17/06, Ayende Rahien <[EMAIL PROTECTED]> wrote:
I can think of several ways to make it happen, but I can't think of a
scenario where this is a good thing.
Self modifying schema is a near contester to self modifying code in by list
of things that I don't want to work with.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto: [EMAIL PROTECTED]] On Behalf Of
hammett
Sent: Saturday, June 17, 2006 4:33 AM
To: [email protected]
Subject: Re: [Castle-users] Use AR to dynamicaly create new table column
Hmm, I think this goes beyond what AR (and I dare to say, NHibernate) has to
offer.
On 6/16/06, Mircea Jivoin < [EMAIL PROTECTED]> wrote:
> Hy everyone,
>
> Does anyone know if it is possible to dynamically or somehow in
> run-time create new table column using AR or NHibernate?
--
Cheers,
hammett
http://hammett.castleproject.org/
_______________________________________________
CastleProject-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/castleproject-users
_______________________________________________
CastleProject-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/castleproject-users
_______________________________________________
CastleProject-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/castleproject-users
_______________________________________________ CastleProject-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/castleproject-users
