monsieur_champs has asked for the wisdom of the Perl Monks concerning the following question:
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
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Record edition management strategy needed
by Abigail-II (Bishop) on Sep 08, 2003 at 15:54 UTC | |
by monsieur_champs (Curate) on Sep 08, 2003 at 17:27 UTC | |
Re: Record edition management strategy needed
by simonm (Vicar) on Sep 08, 2003 at 16:25 UTC | |
Re: Record edition management strategy needed
by bean (Monk) on Sep 08, 2003 at 16:18 UTC | |
by monsieur_champs (Curate) on Sep 08, 2003 at 17:35 UTC | |
by bean (Monk) on Sep 09, 2003 at 22:52 UTC | |
by MrCromeDome (Deacon) on Sep 08, 2003 at 20:27 UTC |