Faster Way to update custom fields

[SBarnes]

In an integration I have been working on it is necessary to update a custom field on an inventory item and in the intial load to the other platform this involves over 9,000 items

Whilst I can use something like the below, to see if the value is set already, is there away to avoid having having to load the business object to save the value to a custom field except for resorting to a raw SQL statement?

Code: Select all

var custValue = JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValueCollection.ReadCustomFieldValue(manager, "Inventory Maintenance", item.TSAInventoryID, "ExternalID");