Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: Prefetching?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Prefetching?

Subject: Re: Prefetching?
From: Stamenkovic Florijan <email@hidden>
Date: Fri, 30 Jan 2009 11:05:12 -0400

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.

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@hidden
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@hidden) Help/Unsubscribe/Update your Subscription: email@hidden

This email sent to email@hidden


_______________________________________________
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


Follow-Ups:

Re: Prefetching?
From: Jeffrey Simpson <email@hidden>
Re: Prefetching?
From: Stamenkovic Florijan <email@hidden>


References:  
  >Prefetching? (From: Jeffrey Simpson <email@hidden>)




Prev by Date:
Re: model.validateKey intercepted on null?

Next by Date:
Re: Prefetching?

Previous by thread:
Prefetching?

Next by thread:
Re: Prefetching?

Index(es):

Date
Thread