Mailing Lists: Apple Mailing Lists

Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Slow Batch Utility



On 25.05.2007, at 01:22, Ted Archibald wrote:

I have a webobjects accounts receivable application that I have a batch utility that changes certain fields everynight. I'm having issues with the speed of the batch utility and I suspect the slowness is due to having to access the full EO.

Is there a way to change the value of a field in an EO WITHOUT having access to the full EO? I know you can do this through a stored procedure, but I would rather not do that. Is there a way to do this in WebObjects?

In addition to what Kieran said:

You can also use raw SQL. Look at EOUtilities.rawRowsForSQL for this. You can fetch raw rows, but you can also execute standard SQL inserts or updates.

You can also go directly to the JDBC level and work there ...

cug
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

This email sent to email@hidden
References: 
 >Slow Batch Utility (From: "Ted Archibald" <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.