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.

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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.com

This email sent to [email protected]


--
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to