> 1.) start a transaction for each individual update and commit it,
> measure the time
> 2.) start a transaction in the beginning, do all your million updates,
> commit at the end, measure the time
> 3.) start a transaction for a group of changes (let's say for every 5k
> changes), commit and start a new transaction until the million updates
> finishes, measure the time
> 4.) Measure the difference between the execution speed of each approach
> 5.) repeat it some times to get a "good" average
> 6.) choose your preferable model
>
>

ooopss.

I mixed the order... it should be

2.) start a transaction for a group of changes (let's say for every 5k
changes), commit and start a new transaction until the million updates
finishes, measure the time

3.) start a transaction in the beginning, do all your million updates,
commit at the end, measure the time


so the rest of the message has any meaning...

Now 3 is the only reliable way and 2 (perhaps) the fastest option as
stated on the previous message...

sorry for the confusion.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br