Re: Newbie: Mixing HTML & WO Pages?
Re: Newbie: Mixing HTML & WO Pages?
- Subject: Re: Newbie: Mixing HTML & WO Pages?
- From: petite_abeille <email@hidden>
- Date: Fri, 24 Oct 2003 12:11:12 +0200
Hi Adam,
On Friday, Oct 24, 2003, at 00:39 Europe/Amsterdam, Adam Chan wrote:
It is different.
Why is that?
Say, assume we have a Product table that contains some 100 thousands
records. The client wants to browse through all the records by
product part
number only at first. While this product table is big; it has many
records
and attributes (actually values, not foreign keys to the other tables,
"faulting ")
Faulting doesn't necessary mean "relationship". You can create a fault
out of the primary key of any object.
, fetching all the attributes together is a waste.
Ok. In that case, what you could do, is specify exactly which
attributes you want to fetch. Depending on your particular
circumstances, this could be as simple as defining a "lightweight" EO
with only the bare minimum amount of information you need.
Alternatively, you can take full control of the fetching by working at
the EOAccess level. The choice is yours.
Note, at this
point, the client cares nothing more than the part number.
Is that the primary key also?
In this case, we
can simply do a SQL raw fetch on part number only.
Right... but you could achieve the same effect in EOF.
Until the client really
want to examine a few products, we can than fetch the EOF base on the
selected part numbers.
Right... so I guess the part number is also the effective primary key,
right? Then you should read this:
"how to create an EO with only a primary key"
http://www.omnigroup.com/mailman/archive/eof/2002-June/002789.html
If you need to take control of the fetch itself, you could try that:
"how to enumerate through a result set one row at the time"
http://www.omnigroup.com/mailman/archive/eof/2002-June/002785.html
Then, if you need to batch fetch a bunch of faults, you could try that:
"batch fetching EOFaults"
http://www.omnigroup.com/mailman/archive/eof/2002-June/002782.html
Cheers,
PA.
_______________________________________________
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.