Dear fellows
I'm building a CGI script at work that permits edition over a lot of fields from a record stored in a database. I'm really concerned about performance, and whish to minimize useless update statements when updating data on this database.

What is the best strategy to update data on the database? Should I update all the fields, every time, or there is something I can do for minimizing the load on the database server?

I'm thinking about building a SQL statement on-the-fly, so I will update only the changed fields, but I don't know if this is the best strategy, or even a Good Way To Do It[tm]. Any help, comments, new issues, suggestion or code skeletons are wellcome.

Many thanks to all in advance.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
monsieur_champs