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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
