Re: multiple database updates from 1 form

From: Eric Bohlman (ebohlman_at_earthlink.net)
Date: 02/26/04 

Date: 25 Feb 2004 23:28:23 GMT

David Mackenzie <me@privacy.net> wrote in
news:2fso30pk56h5b9h82pqptbg7t8h5m76emu@4ax.com:

> On Wed, 25 Feb 2004 04:17:51 GMT, "Comcast" <ewvea3dgc7001 .@.
> sneakemail.com> wrote:
>
>>This solution is working fine, but I hate the idea that I'm updating
>>data that isn't changing. I've considered keeping state when a form is
>>shown, then comparing the values between the original state, and if
>>its different then update the database.
>
> You needn't worry about things like that. The database is capable of
> optimising itself.
>
> From:
> http://www.mysql.com/documentation/mysql/bychapter/manual_SQL_Syntax.ht
> ml#UPDATE
>
> "If you set a column to the value it currently has, MySQL notices this
> and doesn't update it."
>
> I'm sure other RDBMSs have similar optimisations.

Sometimes, though, you want to keep track of when an item was last
modified, and in that case updating everything at once will destroy that
ability.

Relevant Pages

  • Re: datagrid update command
    ... -i display it on a textbox on the form b4 updating the dataset ... >> hi sir ... > always cause error says that CType is not defined inmy namespace, ... > how can i update the database or the dataset without knowing the value ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Looping through a datagrid
    ... updating of the data when the request is posted back to the server. ... This is my> first attempt at creating a working Datagrid and having it update to a> database. ... I have> made some fields in the grid editable and want those changes to hit the> database at the same time with an update button that I have at the bottom of> the grid. ... >> Why would you loop through a data grid? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Please help with a serious issue
    ... be located for updating) they are both invoicing customers that are right ... are updating as well as the previous and next record as sort of a buffer i ... run to a local database and update each night to the server. ... record on a second try because the lock will be removed by the time the user has ...
    (borland.public.delphi.database.ado)
  • Re: Index now option Windows search 4.0
    ... it's database of files on local hard-drives is incomplete for some reason. ... 'magnifying glass' icon in the taskbar? ... time to complete it's updating, until it was complete it too would be ... is this 'Windows Live Desktop Search' that you're ...
    (microsoft.public.windowsxp.general)
  • Re: Unable to update view in Sql Server 2000
    ... > and database-sql server 2000). ... > party component but I don't think the component is the problem. ... > happening is that I'm updating fields that are part of view. ... So it seems that something in the production database ...
    (comp.databases.ms-sqlserver)