>
>
> Could you do the updates in batches instead of trying to do them all at
> once?
Nope. Didn't think it would make any difference.
>
> Have you done a vacuum full on this table ever?
Many times
>
> What hardware?
> I have a dual CPU opteron with 4GB of RAM and 8 disks in RAID 10 (SATA).
> Doing an update on a 5 million record table took quite a while, but it did
> fininish. :-)
I am using a laptop :).
Pentium 4 (not 4M) with 1GB of memory - 2 MHZ
Must do it on that since the program is aimed for use at home.
Jonathan
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.7.4/351 - Release Date: 05/29/2006