StrataFrame Forum

Question about how framework forms SQL statements...

http://forum.strataframe.net/Topic5045.aspx

By Ben Kim - 12/7/2006

Hello,

When inserts and updates SQL statements are created do they include all fields or just fields that have been changed?  If they include all fields are there plans in place to change this feature?   It would dramatically decrease the amount of network traffic and work for SQL server on the backend.

Thanks!

Ben, Emergitech

By StrataFrame Team - 12/7/2006

Yes, updates currently include all fields.  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.  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.