Re: [SQL] unnecessary updates

2002-11-01 Thread Ross J. Reedstrom
Another way to approach this would be to add a trigger to your table in the database, that rejects updates that don't change any values. You'd basically have to hard code that same logic (new.a != old.a or new.b != old.b ...) and it'd fire on every update, so you're talking about trading computatio

Re: [SQL] unnecessary updates

2002-10-30 Thread Andrew Perrin
One strategy is to use some sort of middleware that takes care of this. On a project I did a few years ago, I used a perl module that read the record from Postgres and made it into a perl object. The object contained a variable, "changed", that reflected whether anything had actually changed in the