RE: Query result times in WO and mysql
RE: Query result times in WO and mysql
- Subject: RE: Query result times in WO and mysql
- From: Kent Harris <email@hidden>
- Date: Wed, 21 Jan 2004 07:04:02 -0800
On Jan 20, 2004, at 10:01 PM, Lon Baker <email@hidden> wrote:
Question... Do the direct-to-java-client enumeration entities provide
any advantage vis-a-vis caching and performance or do they simply
express GUI effects (tab view, editing, etc.)? I was going to place
the names of US States in an enumeration entity but Lon's paragraph
below got me to thinking that might be a mistake.
Kent
My other early mistake was to model relationships for a lot of things I
did not need to, such as Countries, States, Status Indicators, etc., I
later found that it was more effective to use dictionaries/arrays of
static values such as these and story the value in the record instead
of a related record. This made the records easier to read in raw
format, less resource intensive to cache or display, and reduced the
load database fetches can have on both the application and the database
server.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.