Fetch Optimization Advice
Fetch Optimization Advice
- Subject: Fetch Optimization Advice
- From: "Mr. Frank Cobia" <email@hidden>
- Date: Wed, 8 Jul 2009 16:19:56 -0400
I have created a WebObjects command line app (uses ERXMainRunner) that
generates a report for each user (40,000+) on my system and it is
running too slow. I have come up with two ways to optimize it and I
was wondering which you thought is better.
The report uses a table (TableA) that has a lot of fields, most of
which are not relevant to the report. It also has a Text field which
could be rather large.
One option is to create TableAReport that points to the same database
table, but only include the few (small) fields that I need for the
report. I know the downside to this is that WebObjects can get
confused when there are two entities pointing to the same data, but
this command line app is only run once a day, it is read only and
(hopefully) only runs for a few minutes.
The other is to go to raw row fetches, but I lose some of the nice EOF
stuff like traversing relationships. (TableA has two relationship I
use).
Any Advice?
Thanks,
Frank
_______________________________________________
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