On Sep 17, 2010, at 1:40 PM, Paula Loehr wrote:
>
>
>
> On 9/17/10 2:35 PM, "Chuck Hill" <ch...@global-village.net> wrote:
>
> >
> > On Sep 17, 2010, at 1:24 PM, Paula Loehr wrote:
> >
> >> Hi,
> >> This is my first time to post a question to this list, so let me know if
> >> I’m
> >> not providing enough information.
> >>
> >>
> >> Here’s my problem:
> >> I’m calculating students’ gpas so I can then get a student’s class rank.
> >> I have one “if” statement that is still causing database hits: if
> >> (this.studentCourse().course().isHighschool()) {
> >
> > What is "this"?
> "this" is one of "transcript.terms.courses"
> >
> >>
> >> Because there could be hundreds of gpas that I’m calculating, I need to
> >> eliminate all database hits during my calculation or it will take too long.
> >>
> >> I’ve added the following batchFetch to try to eliminate these database
> >> hits
> >> and it’s not quite working yet. It’s working for some of the keyPaths, but
> >> not all.
> >> ERXBatchFetchUtilities.batchFetch(students, new
> >> NSArray<String> (new String [] {
> >> "transcript",
> >>
> >> <---- this one works
> >> "finalTranscript",
> >>
> >> <---- this one works
> >> "transcript.student",I would not expect that to fetch anything as student.transcript.student is the same as student which has already been fetched. > >> "transcript.student.schoolStudents", That is the same as "schoolStudents" and is presumably the students array so already fetched. > >> "transcript.terms", > >> > >> <---- this one works > >> "transcript.terms.courses", > >> > >> <---- this one works > >> "transcript.terms.courses.studentCourse", > >> "transcript.terms.courses.studentCourse.course" Not sure why those are not fetching. Double check the keypath and spelling. Chuck > > > > > > transcript.terms.courses.studentCourse.course matches > > this.studentCourse().course() above? > > > > Yes, it does. > > > > Chuck > > > > > >> })); > >> > >> Here are the relationships: > >> transcipt > student >> schoolStudents > >> transcript >> terms >> courses > studentCourse > course > >> > >> Here is the data it’s fetching: > >> transcript : 44 rows (correct) > >> finalTranscript : I don’t see any SQL generated for this fetch > >> transcript.student : or this one (there should be 44) > >> transcript.student.schoolStudents : or this one (there should be 44, it’s > >> a > >> one to many, but it just so happens, that there’s 1 schoolStudent record > >> for > >> each > >> student in this case) > >> transcript.terms : 131 rows (correct) > >> transcript.terms.courses : 1048 (correct) > >> transcript.terms.courses.studentCourse : I don’t see any SQL for this one > >> either > >> transcript.terms.courses.studentCourse.course : or this one > >> > >> > >> I’ve tried variations of the batchFetch statement and tried setting the > >> skipFaultedSourceObjects to true and false, but I always have the same > >> result. > >> > >> Any ideas? > >> > >> Thanks in advance, > >> Paula > >> > >> > >> > >> -- > >> Paula Loehr > >> > >> K12 Inc > >> 719-460-4350 > >> plo...@k12.com > >> > >> _______________________________________________ > >> Do not post admin requests to the list. They will be ignored. > >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > >> Help/Unsubscribe/Update your Subscription: > >> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village. > >> net > >> > >> This email sent to ch...@global-village.net > > -- > Paula Loehr > > K12 Inc > 719-460-4350 > plo...@k12.com > -- 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
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
