3 jun 2008 kl. 16.06 skrev Scott Marlowe:
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;
Mmm I keep that in mind. The problem is that on these tables I only do
INSERTS and DELETES. :)
Maybe I can redesign it but I can find a good way...yet...
Thanks!
