Hi all,

When I originally planned the schema used for our clinical application, I used 
horizontal inheritance. As use has increased, I perceive that horizontal 
inheritance will not scale for more and more entities. Perhaps I should spend 
time measuring the performance impact, but I am planning on ever increasing the 
number of child entities (they act as data collection forms) and so I think 
single-table inheritance is a better fit.

I have two questions.

1. Is there an easy way of migrating? I can see that I could set-up a wholly 
new type of entity / sub entities and then manually migrate old entity data 
into the new ones. This sounds like a considerable piece of work.

2. What happens in single-table inheritance if you have a clash of property 
names but the column name is different (or for that matter the same).

Any advice much appreciated!

Mark

-- 
Dr. Mark Wardle
Consultant Neurologist, University Hospital Wales, Cardiff, UK
Email: [email protected] or [email protected]  Twitter: @mwardle
Telephone: 02920745274 (secretary) or facsimile: 02920744166





 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to