On Tue, Jun 3, 2008 at 7:41 AM, Henrik <henke@xxxxxx> 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;
