Re: Changing from horizontal to single table inheritance
Re: Changing from horizontal to single table inheritance
- Subject: Re: Changing from horizontal to single table inheritance
- From: Mark Wardle <email@hidden>
- Date: Sat, 05 Oct 2013 22:25:17 +0100
| Thanks both,
This advice is all very helpful. I might do some performance measurement to see whether keeping horizontal inheritance is actually causing problems. I think I'm batch fetching which should mean joining on multiple tables and not a SELECT on each and every entity.
The problem is that with single table inheritance, combining all data forms, I will end up with a database table with 449 columns - which might have its own set of problems!
Out of curiosity, am I going to hit any problems combining approaches? Using single table inheritance when there are many common properties and using horizontal inheritance when the majority of properties are not shared.
What I should do instead is write a generic entity which itself stores a runtime-defined, stored in the database (and modelling in EOF) bunch of properties in an NSDictionary and has logic provided a runtime chosen delegate. Then I could create new data collection forms using a dedicated UI and little overhead. Then we'd just set-up a bunch of D2W rules to ask the generic entity for displayPropertyKeys etc. for the appropriate fake entity. Anyone created fake entities like this either?
Best wishes,
Mark
On 4 Oct 2013, at 19:23, Chuck Hill < email@hidden> wrote:
On 2013-10-04 11:06 AM, "Ramsey Gurley" wrote:
Not to contradict Chuck (he is always right),
Will someone PLEASE tell my wife?
--
Chuck Hill
Executive Managing Partner, VP Development and Technical Services
Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing Companies in B.C!
Global Village Consulting ranks 44th in 25th annual PROFIT 500 ranking of Canada’s Fastest-Growing Companies by PROFIT Magazine!
-- Dr. Mark Wardle Consultant Neurologist, University Hospital Wales, Cardiff, UK Email: email@hidden or email@hidden 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden