Hi Jeffrey,
Are you referring to relationship prefetching? As in: a row in table1
relates to many rows in table2, and you want to prefetch table2 rows
based on that relationship?
If so, well, I would assume most people use it, as it can drastically
increase your performance.
Say you have a single row in table1, and 1000 rows in table2 relating
to it. Let's assume that you will for sure need those 1000 rows in
your app... If you pre-fetch the table1 ->> table2 relationship when
fetching table1 row(s), then those 1000 objects will be fetched from
the database immediately using a single select, resulting in total in
a few selects, as opposed to (a few + 1000) selects... This can speed
fetching up *a lot*, and is in many situations not only beneficial,
but a must-do.
Does this help? If you are referring to something else, please clarify.
F
On Jan 30, 2009, at 10:18, Jeffrey Simpson wrote:
I was reading though WebObjects Documentation and ran across a
section on
Prefetching. I then looked through the mailing list and did not
find any
messages about it.
Does anyone use it?
Is it worth using?
Jeffrey Simpson
Youth For Understanding USA
[email protected]
Telephone: (240) 235-2114
FAX: (202) 235-2104
Preparing young people for their responsibilities and opportunities
in a
changing, interdependent world.
_______________________________________________
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/
flor385%40mac.com
This email sent to [email protected]
_______________________________________________
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]
