Hello, I am trying to switch from MS Access to a more reliable
Java FrontEnd and MySQL backend version. I have managed to design and display records from the table, link tables and display records on the same interface.. Now I am stuck up at UPDATE. Problem is because my Customer table is big.. like 88 columns.. I know how to update table.. but want a better efficient way to do it..
I am thinking of few options,
1. To update the entire row if the button is pressed.. (which is a lot, as sometime they might only change the Title from Ms to Mrs).
2. Create flags, and update columns only if the flag value is true.. (this is highly expensive, as it needs 88 flags declared, 88 if conditions for computing which fields to update)
3. Create tabbed panels, and update only the panels where changes are made. (this is again going to be huge, as we might end up in condition 1, if only one field is changed in the particular tab)
If the above options are all rubbish, can someone give me a better idea for update?? I am worried a bit about this..