Re: Altering EOModel
Re: Altering EOModel
- Subject: Re: Altering EOModel
- From: Chuck Hill <email@hidden>
- Date: Fri, 12 Mar 2010 10:30:47 -0800
On Mar 12, 2010, at 10:23 AM, Chuck Hill wrote:
On Mar 12, 2010, at 7:23 AM, Kieran Kelleher wrote:
Hi Chuck,
Resurrecting this old thread....
What do you mean by "moderate"? For example a virtual table with 20
fields, half being numbers and half being varchar255 strings, how
many virtual records would be regarded as too much?
It is highly dependent on the server configuration (modern xServe vs
your old Mac Mini), how many tables there how, usage frequency,
etc. I'd ballpark it as 30,000 to 100,000 "fields" (rows x fields
per table). There are 5 system fields that need to be included. So
100,000 / 25 = 4,000 rows. 1,200 rows if you limit it at 30K fields.
All that said, Sacha recently did a lot of optimization on this (for
version 4.6 IIRC). I am not sure if these numbers include that
optimization. He is away on vacation until April.
I should also mention that this is from a site with a lot of users
and a lot of tables, so we were trying to balance functionality (store
whatever you want) against overall responsiveness.
Chuck
On Jan 19, 2009, at 3:22 PM, Chuck Hill wrote:
On Jan 16, 2009, at 12:20 PM, Stavros Panidis wrote:
Hi all,
I am developing an application where I want to give to the end
user the ability to alter EOModel and database, that is to add
fields in a table, or to add a new table and to be able to insert
and/or edit data on this table.
I am sure that there is a way to do it but as with the whole
WebObjects documentation is a miracle to find out how (at least
for a new comer like me).
Can anyone suggest to me some APIs or readings about this?
Many thanks in advance
Along with the other good advice you have been given, I will
mention our Virtual Tables framework. It allows you to create new
EO-like entities and objects on the fly. These can't have any
code, but have full KVC access like normal EOs. They work fine
for small to moderate data sets. For larger ones, you will
probably find the performance inadequate.
You can get a recent copy from http://www.gvcsitemaker.com/chill/files/gvcframeworks_source.tar.gz
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve
specific problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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