StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Question about how framework forms SQL statements...InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumFri, 25 Sep 2026 22:43:31 GMT20Question about how framework forms SQL statements...http://forum.strataframe.net/FindPost5045.aspxHello,</P><P>When inserts and updates SQL statements are created do they include all fields or just fields that have been changed?&nbsp; If they include all fields are there plans in place to change this feature?&nbsp;&nbsp; It would dramatically decrease the amount of network traffic and work for SQL server on the backend.</P><P>Thanks!</P><P>Ben, EmergitechThu, 07 Dec 2006 10:07:17 GMTBen KimRE: Question about how framework forms SQL statements...http://forum.strataframe.net/FindPost5055.aspxYes, updates currently include all fields.&nbsp; The reason for this was to allow support for stored procedure updates and to allow the update commands to be cached, which improved performance more than specifying only the fields that had changed.&nbsp; The way SF handles updates will be changed significantly in the next major version of SF where LINQ support is implemented, most likely allowing you to configure whether only modified field should be updated, or all fields.Thu, 07 Dec 2006 10:07:17 GMTStrataFrame Team