Ticket AS5031
Visible to All Users

Update SQL statement must include modified properties only

created 19 years ago

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!

Answers

created 19 years ago

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

    Comments (1)
    DevExpress Support Team 14 years ago

      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

      Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

      Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.