I am experiencing very slow update performance using XPO for large tables.
The reason is clear: XPO always stores all persistent fields whenever they are modified or not. So by changing a single property and saving the object, XPO creates the UPDATE statement which includes all properties!
Update SQL statement must include modified properties only
Answers
The next version (XPO 6.2) will provide a Session.GetPropertiesListForUpdateInsert virtual method. You will be able to inherit the Session class and override the GetPropertiesListForUpdateInsert method to return a list of fields which must be included in the Update SQL.
Thank you
With v2010 vol 2, you can assign true to the UpdateModifiedOnly parameter of the DelayedAttribute, to ensure that the related delayed property is only sent to the database for update if it has actually been modified. To learn more, refer to Suggestion ID: S35995, Provide the capability to update delayed properties only if they were modified.
Thanks,
DevExpress XPO Team