On Tue, Jun 3, 2008 at 7:41 AM, Henrik <henke(at)mac(dot)se> wrote:
>
> To be able to handle versions we always insert new folders even though
> nothing has changed but it seemd like the best way to do it.
>
> E.g
>
> First run:
> tbl_file 500k new files.
> tbl_folder 50k new rows.
> tbl_file_folder 550k new rows.
>
> Second run with no new files.
> tbl_file unchanged.
> tbl_folder 50k new rows
> tbl_file_folder 550k new rows.
On useful trick is to include a where clause that prevents the extra updates.
I.e. update table set field=123 where field <> 123;